Creating a Monthly Line Chart for Average DAU Breakdown

Hi Yanisa S., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

To set up a dashboard that shows average Daily Active Users (DAU) breakdown by month in a line chart using Mixpanel, you can follow these steps: 1. Create a new Insights report in Mixpanel.2. Choose your event that defines an active user. This could be any meaningful engagement event in your product.3. Set the measurement to "Daily Active Users (DAU)" instead of the default "Unique Users". You can do this by clicking on the measurement dropdown and selecting "Daily Active Users (DAU)" under the "Users" section.4. Set your time range to cover the period you want to analyze.5. Change the time interval to "Month" to get a monthly breakdown.6. For visualization, select "Line" chart from the chart type options.7. Once you've created this report, you can add it to your dashboard.This setup will give you a line chart showing the average DAU for each month over your selected time period.It's important to note that when you select DAU and group by month, Mixpanel will automatically calculate the average DAU for each month. This is because DAU is a daily metric, and when you're looking at it over a longer time period like a month, it makes sense to look at the average.For more detailed instructions on using Insights and creating reports, you can refer to the Mixpanel Docs on Insights.Remember, the exact definition of an "active user" will depend on your specific product and business goals. Make sure to choose an event that truly represents meaningful engagement for your product.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

To change the time interval to "Month" in Mixpanel to get a monthly breakdown, you can follow these steps: 1. In your Insights report, look for the time interval selector. By default, it's often set to "Day".2. Click on this selector to open the dropdown menu.3. From the options presented, choose "Month".This process is part of the advanced date and time selectors in Mixpanel. According to the Mixpanel documentation on Advanced Features, you can "choose how Mixpanel buckets the time range in Insights, Funnel Trends and Retention Trend reports (granularity may vary)."The documentation states: "To view a range in hours, you can select Hour as the view". While this example specifically mentions hours, the same principle applies for selecting "Month" to get a monthly breakdown.By changing the interval to "Month", your data will be aggregated on a monthly basis, allowing you to see trends and patterns over longer periods of time.Remember that changing the time interval affects how your data is displayed and can significantly impact your analysis, so choose the interval that best suits your analytical needs.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

Based on the information provided in the knowledge sources, I don't have specific details about limitations on selecting "Month" interval when using Daily Active Users (DAU) as a metric. However, I can provide some insights that might help explain what you're experiencing.The limitation you're encountering is not related to being on the Growth plan. The reason you can only select "Day" as an interval when using DAU is likely due to the nature of the DAU metric itself.DAU stands for Daily Active Users, which by definition is a daily metric. As explained in the Mixpanel blog post about MAU, WAU, and DAU: "DAU measures how many users were active in a given day."Given this definition, it wouldn't make sense to measure DAU on a monthly interval, as it's inherently a daily metric. When you select DAU, Mixpanel is likely restricting the interval options to ensure the metric is used correctly.If you want to see a monthly breakdown of user activity, you might consider using Monthly Active Users (MAU) instead. MAU would allow you to select a monthly interval and see how your active user count changes from month to month.Alternatively, if you specifically need to see DAU data over a longer period, you might be able to use the "Day" interval and then use Mixpanel's analysis settings to view a rolling average or cumulative count over time. According to the Mixpanel documentation on Analysis Settings, you can access these options by going into the advanced section of the measurement menu.If you're still unsure or if you believe this is unexpected behavior, I recommend reaching out to Mixpanel's support team for clarification, as they would have the most up-to-date and specific information about the platform's functionality.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

To show the average Daily Active Users (DAU) for each month in Mixpanel, you can use the following approach: 1. Create a new Insights report in Mixpanel.2. Select the event that defines an active user for your product.3. Set the measurement to "Daily Active Users (DAU)".4. Set your desired time range for analysis.5. Keep the time interval as "Day" (since DAU is inherently a daily metric).6. For visualization, select "Line" chart.7. Now, to get the monthly average, you'll need to use the "Rolling Average" analysis setting. According to the Mixpanel documentation on Analysis Settings: "Rolling Average: Rolling analysis calculates the rolling average of the data set. A rolling average curve is a series of averages from subsets of data. Use rolling average analysis to remove noise or spikes from data and smooth out trends over time."8. To access this, go to the advanced section of the measurement menu and select "Rolling Average".9. Set the rolling average period to 30 days. This will effectively give you the average DAU for each month.This approach will show you a smoothed line chart representing the 30-day (approximately monthly) rolling average of your DAU. Each point on the line will represent the average DAU for the past 30 days, giving you a good approximation of the monthly average DAU.Remember, as mentioned in the Mixpanel blog about MAU, WAU, and DAU, "DAU measures how many users were active in a given day." By using the rolling average, we're extending this daily metric to give you a monthly perspective while still maintaining the daily granularity that DAU requires.If you need exact calendar month averages, you might need to export the daily data and calculate the averages manually, or consider using a custom event or metric that aggregates DAU on a monthly basis.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.