DAU/MAU Chart

Hey @Omriko 

You can use this custom formula to chart out DAU/MAU  :

UNIQUES(A)/ROLLWIN(UNIQUES, A, 30)
 

You can read more on these in the following posts -

• How can I calculate DAU/WAU?

Hope this helps.

Saish Redkar wrote:

Hey @Omriko 

You can use this custom formula to chart out DAU/MAU  :

UNIQUES(A)/ROLLWIN(UNIQUES, A, 30)
 

You can read more on these in the following posts -

• How can I calculate DAU/WAU?

M

• Chart for WAU/MAU

 

Hope this helps.

Thank you, and if i want the flat numbers of the window, just remove the first part right (nominator)?

Thanks!

I have another question, sorry as I'm a bit confused.

If I wanted the daily active users, just as simple as that, what would I need to do?

I want to see daily active users not events..

Should I use the segmentation chart → any active event -→ group by user ID?

@Saish Redkar 

Thanks!

@Omriko 

Responded in this

@Saish Redkar i’m using your UNIQUES(A)/ROLLWIN(UNIQUES, A, 30) but as a followup to this, i’d want to take out non-working days to prevent this chart behavior: 

which is caused by weekends when close to zero users are using our B2B saas tool 😁. 
Any thoughts?

update: i’ve just read up here that it’s not possible and would be a feature request
 

@klaas 

They now have the “Event Day of Week” property filter wherein you can chose the days if you have access to that. Not sure if this is GA to all customers or not yet.

I tried charting the 30 day rolling win formula - with weekends vs without weekends in this demo chart

So I’m assuming every datapoint in there will have the rolling sum of the past 30 days excluding any data from a Saturday and a Sunday.

Hope this helps