Solved

DAU/MAU Chart

  • 29 July 2022
  • 8 replies
  • 1432 views

Userlevel 1
Badge

Hi community,

 

I’m trying to create something like the attached picture

is it as simple as looking at unique users group by week?

trying tp create something like this where i assume its a rolling period?

 

icon

Best answer by Saish Redkar 29 July 2022, 17:26

View original

8 replies

Userlevel 7
Badge +10

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 -

 

Hope this helps.

Userlevel 1
Badge

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 -

 

Hope this helps.

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

Userlevel 7
Badge +10

Yea, ROLLWIN(UNIQUES, A, 30) will give you rolling 30 day uniques per datapoint.

Userlevel 1
Badge

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!

Userlevel 7
Badge +10

@Omriko 

Responded in this

 

Badge

@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?

Badge

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

 

Userlevel 7
Badge +10

@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

 

 

Reply