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:

[pratap6699]

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

[#3]

Attached a file to the title post.

[swuehl · Accepted solution]

Attached a sample QVW with your data.

[#5]

Thanks! It's works.