topic Re: One months DAU in QlikView

One months DAU

Wed, 03 Jun 2015 10:11:17 GMT

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:

Re: One months DAU

swuehl — Wed, 03 Jun 2015 10:22:48 GMT

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)

Re: One months DAU

Wed, 03 Jun 2015 10:33:44 GMT

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.

Re: One months DAU

sunny_talwar — Wed, 03 Jun 2015 10:37:07 GMT

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

Try something like this:

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

HTH

Best,

Sunny

Re: One months DAU

swuehl — Wed, 03 Jun 2015 10:39:37 GMT

You probably need below()

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

Re: One months DAU

sunny_talwar — Wed, 03 Jun 2015 10:43:49 GMT

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

Re: One months DAU

sunny_talwar — Wed, 03 Jun 2015 10:46:31 GMT

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

Re: One months DAU

Wed, 03 Jun 2015 10:48:17 GMT

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

I neen to find DISTINCT vistiors for these 30 days

Re: One months DAU

sunny_talwar — Wed, 03 Jun 2015 11:04:13 GMT

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

Best,

Sunny

Re: One months DAU

swuehl — Wed, 03 Jun 2015 11:34:12 GMT

Maybe like attached?

Re: One months DAU

pratap6699 — Wed, 03 Jun 2015 12:11:36 GMT

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

Re: One months DAU

Wed, 03 Jun 2015 12:39:15 GMT

Attached a file to the title post.

Re: One months DAU

swuehl — Wed, 03 Jun 2015 13:00:14 GMT

Attached a sample QVW with your data.

Re: One months DAU

Wed, 03 Jun 2015 14:28:48 GMT

Thanks! It's works.