Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Attached a sample QVW with your data.
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)
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.
You will need RangeSum(Above)) in your case then...
Try something like this:
=RangeSum(Above(Count(DISTINCT visitorId), 0, 30))
HTH
Best,
Sunny
You probably need below()
=RangeSum(Below(Count(DISTINCT visitorId), 0, 30))
Yup, depending on how the data is sorted, she might need above or below
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
This formula calculate distinct vistiors per every day and then sum it.
I neen to find DISTINCT vistiors for these 30 days
Would you be able to share some sample data to work on?
Best,
Sunny
Maybe like attached?