Display Absolute Numbers and Percentages in Insights Reports
Is there a way to show both the absolute number and the percentage of the total in an insights report?
Yes, there is a way to show both the absolute number and the percentage of the total in a Mixpanel Insights report. This can be achieved using the "Value Comparisons" feature.According to the Mixpanel documentation: "When you have multiple metrics, or have broken down a metric by a property, you can compare them against each and the relative value. Click on Compare -> Overall. This works for all measurements. For a 'totals' measurement, you can see the percentage that a particular segment makes up. For non-sumable aggregations, it compares the segment value to the whole, unsegmented value."By using this feature, you can view both the absolute numbers for each segment and their relative percentages compared to the overall total. This allows you to see both the raw data and the proportional representation in the same report.It's important to note that depending on the type of metric you're using, the percentages may not always add up to 100%. The Mixpanel documentation explains: "Depending on the type of metric, the percentages may not add up to 100%. This is because the value is being compared to the unsegmented value. [...] More generally, if the metric is summable, and the groups are mutually exclusive, then the percentages will add up to 100%. If the metric is a non-counting metric like uniques or percentile aggregation, the percentages will not add up to 100%."This feature provides a comprehensive view of your data, allowing you to see both absolute and relative values in your Insights 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.