Generating DAU, WAU, and MAU Graphs by User Segment in Mixpanel

Nitya G. · 2025-09-18T21:02:08.147Z

I want to see DAU, WAU, and MAU in one graph at monthly level. In order to achieve this, I want to calculate the avg of DAU and WAU users to show in the graph. Now this graph, needs to be segmented for 3 users - all, active and buyers. How to get this output in mixpanel?

Generating DAU, WAU, and MAU Graphs by User Segment in Mixpanel | Mixpanel Community

1 comment

· Sorted by Oldest

kapa.ai
APP
·
·
To visualize DAU, WAU, and MAU together at a monthly level in Mixpanel, and to show the average DAU and WAU alongside MAU, segmented by user types (all, active, buyers), follow these steps:
1. Create an Insights Report
- Go to the Insights report in Mixpanel. - Select the event(s) that define your active users (e.g., "App Opened" for all users, "Active" for active users, "Purchase" for buyers).
2. Add DAU, WAU, and MAU Metrics
- For each event, use the advanced settings to select the Unique Users measurement, then choose DAU, WAU, and MAU as the functions. - This will add three separate lines (or bars) to your graph for each metric. - Set the time interval to Month to view the metrics at a monthly level.
3. Calculate Average DAU and WAU
- Use the Formula feature in Insights to calculate the average DAU and WAU for each month: - Click the +Formula button. - Assign variables to your DAU and WAU metrics (e.g., A for DAU, B for WAU). - Create formulas like A (for avg DAU) and B (for avg WAU) as needed. Mixpanel automatically averages DAU and WAU over the selected interval when the interval is set to Month. - You can also create a custom formula if you want to combine or compare these metrics (e.g., (A+B)/2 for the average of DAU and WAU).
4. Segment by User Type
- Use Cohorts or event filters to segment your users: - All users: No filter or cohort needed. - Active users: Define a cohort for users who meet your "active" criteria (e.g., performed a key event in the last X days). - Buyers: Define a cohort for users who have completed a purchase. - Apply these cohorts as filters to your report, or duplicate the report for each user type.
5. Visualize and Compare
- Your graph will now show DAU, WAU, MAU, and their averages for each user segment at the monthly level. - You can use the Compare feature to view all three user types in the same graph, or create separate graphs for clarity.
References
- How to select DAU, WAU, MAU in Insights and use formulas: Insights: Visualize trends and compositions within your data, Insights: Advanced - How to segment by cohorts: Ultimate guide to cohort analysis - Example of setting up MAU, DAU, WAU at different intervals: Insights: UsersIf you need to see all three user types in a single graph, use the Breakdown feature by cohort or user property. Otherwise, create separate reports for each segment and add them to a Mixpanel Board for side-by-side comparison.> Note: The exact steps may vary slightly depending on your Mixpanel plan and data model, but the above workflow is supported by Mixpanel’s Insights and Cohorts features. If you need to save formulas for reuse, this is available on Growth and Enterprise plans only. If you need more detailed step-by-step instructions or run into a limitation, let me know!
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

kapa.ai
APP
·
·
To visualize DAU, WAU, and MAU together at a monthly level in Mixpanel, and to show the average DAU and WAU alongside MAU, segmented by user types (all, active, buyers), follow these steps:
1. Create an Insights Report
- Go to the Insights report in Mixpanel. - Select the event(s) that define your active users (e.g., "App Opened" for all users, "Active" for active users, "Purchase" for buyers).
2. Add DAU, WAU, and MAU Metrics
- For each event, use the advanced settings to select the Unique Users measurement, then choose DAU, WAU, and MAU as the functions. - This will add three separate lines (or bars) to your graph for each metric. - Set the time interval to Month to view the metrics at a monthly level.
3. Calculate Average DAU and WAU
- Use the Formula feature in Insights to calculate the average DAU and WAU for each month: - Click the +Formula button. - Assign variables to your DAU and WAU metrics (e.g., A for DAU, B for WAU). - Create formulas like A (for avg DAU) and B (for avg WAU) as needed. Mixpanel automatically averages DAU and WAU over the selected interval when the interval is set to Month. - You can also create a custom formula if you want to combine or compare these metrics (e.g., (A+B)/2 for the average of DAU and WAU).
4. Segment by User Type
- Use Cohorts or event filters to segment your users: - All users: No filter or cohort needed. - Active users: Define a cohort for users who meet your "active" criteria (e.g., performed a key event in the last X days). - Buyers: Define a cohort for users who have completed a purchase. - Apply these cohorts as filters to your report, or duplicate the report for each user type.
5. Visualize and Compare
- Your graph will now show DAU, WAU, MAU, and their averages for each user segment at the monthly level. - You can use the Compare feature to view all three user types in the same graph, or create separate graphs for clarity.
References
- How to select DAU, WAU, MAU in Insights and use formulas: Insights: Visualize trends and compositions within your data, Insights: Advanced - How to segment by cohorts: Ultimate guide to cohort analysis - Example of setting up MAU, DAU, WAU at different intervals: Insights: UsersIf you need to see all three user types in a single graph, use the Breakdown feature by cohort or user property. Otherwise, create separate reports for each segment and add them to a Mixpanel Board for side-by-side comparison.> Note: The exact steps may vary slightly depending on your Mixpanel plan and data model, but the above workflow is supported by Mixpanel’s Insights and Cohorts features. If you need to save formulas for reuse, this is available on Growth and Enterprise plans only. If you need more detailed step-by-step instructions or run into a limitation, let me know!
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

1 comment

1. Create an Insights Report

2. Add DAU, WAU, and MAU Metrics

3. Calculate Average DAU and WAU

4. Segment by User Type

5. Visualize and Compare

References