One months DAU

[#1]

Hi.

I have simple Daily Active Users (DAU) Bar Chart.

It has one dimension – “day” and one expression – “count (distinct vistorId)”

The question is: How can I to calculate “one months DAU” – all users, which visited site in period between “this day” and “this day”-30 days.

Thank you.

Sample data:

[swuehl]

You can do this with set analysis.

Your day field needs to be a QV date field, its saying something like '06/03/2015' for today, right? And shows also a numeric representation?

Then try something like

=count({<day = {">=$(=Date(today()-30))<=$(=today())"}>} distinct visitorId)

[#3]

This formula is correct, but I need calculation for every day in my chart, not only for today.

The formula should be something like this:

count({<day = {">=$(=day-30)<=$(=day)"}>} distinct visitorId)
But I can not use the data from dimension in set analysis.

[sunny_talwar]

You will need RangeSum(Above)) in your case then...

Try something like this:

=RangeSum(Above(Count(DISTINCT visitorId), 0, 30))

HTH

Best,

Sunny

[swuehl]

You probably need below()

=RangeSum(Below(Count(DISTINCT visitorId), 0, 30))

[sunny_talwar]

Yup, depending on how the data is sorted, she might need above or below

[sunny_talwar]

PFA a sample with two options (second option is available only for straight table and first option may need to be altered if you are using a pivot table)

Best,

Sunny

[#8]

This formula calculate distinct vistiors per every day and then sum it.

I neen to find DISTINCT vistiors for these 30 days

[sunny_talwar]

Would you be able to share some sample data to work on?

Best,

Sunny

[swuehl]

Maybe like attached?