Changing Overall Calculation from Sum to Average in Reports
How can I change the calculation in the "Overall" line? For example, I would like the overall to show the average values and not the sum
Hi Robert Š., 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
In Mixpanel, the "Overall" calculation depends on the measurement type you're using in your report. By default, for summable metrics like "Total Events," the Overall shows the sum of all segments. However, you can change this calculation by selecting a different measurement type.To show average values instead of sum in the Overall line: 1. In your Insights report, click on the measurement dropdown (it might currently show "Total" or "Unique Users") 2. Select "Aggregate Property" or "Aggregate Property per User" depending on your needs 3. Choose "Average" as the aggregation type 4. Select the property you want to averageThis will change your entire report to show averages instead of sums, including the Overall line.For more context, Mixpanel's comparison features allow you to see how segments perform relative to the overall value. When using "Compare to Overall," the percentages may not add up to 100% depending on the metric type. As explained in the documentation: > "If the metric is a non-counting metric like uniques or percentile aggregation, the percentages will not add up to 100%." Comparison: Time, Baseline and OverallThe calculation method for the Overall line is tied to the measurement type you select, so changing from a sum to an average requires changing the fundamental measurement of your report.
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.