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!
Solved
Chart for WAU/MAU
Best answer by Saish Redkar
Hey
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.
+10Hey
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.
Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
Hi
Hi
- If your chart looks at a daily interval, you can use the custom formula: ROLLWIN(UNIQUES, A, 7)/ROLLWIN(UNIQUES, A, 30) to view the ratio of the number of users in the last 7 days and 30 days. I’ve made an example chart in our Demo to illustrate.
- For a date range based on calendar dates, a workaround would be to create two charts (one with DAU, the other with MAU), and use our Dashboard REST API or CSV export to export chart data for calculation outside of Amplitude.
Hope this helps! Let me know if you have any further concerns!
Best,
Thao
+10If you should be totally precise, I believe it’s possible something like below. But to be honest I would go with Saish’s approach!
- create derived event properties for yearweek and yearmonth (assuming you can access derived properties)
- create an event segmentation with two “any active event”, and group them by yearweek and yearmonth
- set the chart to bar chart and set the time picker to last 12 months
- use a custom formula to get the ratio
Timothy | Product Analytics Consultant - permutable.co
Reply
Welcome to the Amplitude Community!
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're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
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.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.