How do I calculate the average per each day of the week, so I have the breakdown by users Monday - Sunday but I want to know the average number of users or sessions observed every day of each week and want the same done for sessions
Hi event, 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> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To calculate the average number of users or sessions for each day of the week (Monday–Sunday) in Mixpanel, you can use the Insights report with the following approach:
1. Breakdown by Day of Week: In the Insights report, select your event (e.g., "Session Start" for sessions or any user event for users). Then, apply a breakdown by the "Day of Week" property. This will segment your data so you can see counts for each day (Monday, Tuesday, etc.).
2. Select the Measurement: - For users: Choose the "Unique Users" measurement to count the number of unique users per day. - For sessions: Choose the "Count Sessions" measurement to count the number of sessions per day.
3. Set the Time Interval: Set the time interval to "Day" and select a date range that covers multiple weeks. This will give you daily data points, each labeled with the corresponding day of the week.
4. Calculate the Average: Use the "Average" aggregation option in the advanced settings. This will compute the average number of users or sessions for each day of the week across your selected date range. For example, you’ll get the average number of users on all Mondays, all Tuesdays, etc.
- In Mixpanel, after breaking down by day of week, you can select the "Average" aggregation to see the average per segment (i.e., per day of week) over the selected period. This is available for both users and sessions measurements.
Summary of Steps in Mixpanel UI: - Go to Insights report. - Select your event. - Set measurement to "Unique Users" (for users) or "Count Sessions" (for sessions). - Breakdown by "Day of Week". - Set time interval to "Day" and select your date range. - In the aggregation options, select "Average" to get the average per day of week.
This approach will give you the average number of users or sessions observed on each day of the week (Monday–Sunday) over your selected time period, as supported by Mixpanel’s measurement and aggregation features Docs / Reports / Insights: Measurements and Docs / Reports / Insights: Users.
If you want to do this programmatically, you can use the Query API with the appropriate parameters to get daily data, then aggregate by day of week in your own analysis layer if needed. The API allows you to fetch unique user or session counts per day, which you can then group and average by weekday in your code Query API - Event Breakdown.
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.
Let me check the knowledge base for you again. One moment! 📚
In Mixpanel's Insights report, "setting the time interval to day" means configuring your report so that the data is grouped and displayed for each individual day within your selected date range. This allows you to see daily trends and breakdowns, such as the number of users or sessions for each day.
How to set the time interval to "Day":
1. In the Insights report, after selecting your event and measurement, look for the time interval selector—this is usually found near the date range picker or in the chart settings. 2. Choose "Day" as the interval. This will display your data with each data point representing a single day.
This setting ensures that your breakdown (e.g., by "Day of Week") will show the counts for each day, and you can then use aggregation options like "Average" to get the average per day of the week.
In Insights, you can choose to get a metric calculated either across the entire time period selected in the date picker or on a time-segmented view of the metric (e.g. daily breakdown) — Docs / Reports / Insights: Basic Features
If you do not see the interval option, ensure you are using a chart type that supports time segmentation, such as a line chart.
Let me know if you need step-by-step visuals or further clarification!
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.
4. Calculate the Average: Use the "Average" aggregation option in the advanced settings. This will compute the average number of users or sessions for each day of the week across your selected date range. For example, you’ll get the average number of users on all Mondays, all Tuesdays, etc. Show me exactly how kapa.ai
Let me check the knowledge base for you again. One moment! 📚
To calculate the average number of users or sessions for each day of the week in Mixpanel Insights, follow these steps based on the available documentation:
1. Select Your Event and Measurement - In the Insights report, select the event you want to analyze (e.g., "Session Start" for sessions). - Choose the measurement: - For users: select Unique Users. - For sessions: select Count Sessions or use the "Session Start" event.
2. Breakdown by Day of Week - Add a breakdown by the property Day of Week. This will segment your data into Monday, Tuesday, etc.
3. Set the Time Interval to "Day" - In the Insights report, there is an option to set the time interval (granularity) for your data. - Set this to Day so that each data point represents a single day. This is typically found near the date range selector or in the chart settings. - This ensures your data is grouped by each day within your selected date range, which is necessary for averaging by day of week. - See more on time intervals.
4. Apply the "Average" Aggregation - After breaking down by "Day of Week," click on the aggregation option (often labeled as "Total," "Sum," or "Average" depending on your measurement). - Select Average from the aggregation options. - This will calculate the average number of users or sessions for each day of the week across your selected date range. - The documentation confirms that after selecting a breakdown, you can choose different aggregation options, including "Average" (Docs / Reports / Insights: Measurements).
Summary Table from Documentation:
Selecting any of these functions gives you the option to choose different ways to aggregate this data. The default aggregation is Average, which you can click on to select a different option such as distribution, median, 25/75/90th percentiles, minimum, and maximum. — Docs / Reports / Insights: Measurements
If you do not see the "Average" option: - Make sure you are using a measurement and breakdown that supports aggregation. - The "Average" aggregation is available for per-user and property-based measurements.
If you need more detailed, step-by-step visuals, the documentation does not provide screenshots, but the above steps are directly supported by Mixpanel's Insights report features. If you do not see the options as described, your project or event setup may differ, or you may need to check for property availability.
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.
