I was working with a customer on setting up some charts and they were looking to set up a chart to calculate DAU/WAU. i.e. daily active users divided by weekly active users. Would this be something we can set up using custom formulas?
Best answer by Saish Redkar
I believe we can do this using custom formulas in event segmentation charts
UNIQUES(A)/ROLLWIN(UNIQUES, A, 7)
The interpretation of this ratio depends on how we are aggregating the event segmentation chart. ie. daily vs weekly vs monthly.
We can also use this to calculate DAU/MAU ( stickiness) : UNIQUES(A)/ROLLWIN(UNIQUES, A, 30)
Hope this helps!