Hi everyone, do you know how I can create a chart to see WAU/MAU? Only been able to find DAU/MAU on the community. Thank you!
Best answer by Saish Redkar
View originalHi everyone, do you know how I can create a chart to see WAU/MAU? Only been able to find DAU/MAU on the community. Thank you!
Best answer by Saish Redkar
View originalHey
I haven’t personally dived into this metric yet, but can loosely translate the DAU/MAU formula to a WAU/MAU. This
Since our numerator is WAU, we will have to start with a weekly chart interval and do a rolling over the last one month defined in weeks. So a custom formula like : UNIQUES(A)/ROLLWIN(UNIQUES, A, 4) with a chart interval of Weekly . Here’s a demo chart using this formula - https://analytics.amplitude.com/demo/chart/new/duv4m8x
This approach could be slightly inaccurate since there could be caveats in here - 4 full weeks need not translate to one full month always and 5 weeks overshoot the 30 day time period. Not quite sure if Amplitude allows to use of a 30 day window in the denominator, but still sticking with a weekly aggregation.
Would love to hear thoughts and alternate / better approaches from others one this one. Hope this helps to some extent.
Thank you, Saish! I will leave this open for others to chime in on how to produce this chart.
Hi
Hi
Hope this helps! Let me know if you have any further concerns!
Best,
Thao
If you should be totally precise, I believe it’s possible something like below. But to be honest I would go with Saish’s approach!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.