How can I calculate the total percentage of users who made a change, segmented by a breakdown property, and include the percentage of users who made no changes?
Hi Iva Đ., 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 total percentage of users who made a change, segmented by a breakdown property, and include the percentage of users who made no changes, you can use Mixpanel's Insights report with the "Percentage of Overall" comparison feature. Here's how you can do this:1. Set up your Insights report with the event that represents the change you want to measure.2. Apply the breakdown by the property you want to segment by.3. In the top right corner, click on "Compare" and select "Percentage of Overall" from the dropdown menu.4. To include users who made no changes, you may need to create a custom event or use a filter to identify these users.The "Percentage of Overall" feature will show how each segment performs as a percentage of the total. This allows you to see the distribution of users across different segments, including those who made changes and those who didn't.It's important to note that depending on the type of metric and breakdown, the percentages may not always add up to 100%. As explained in the Mixpanel documentation on Comparisons:"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%."If you need more specific guidance on setting up this analysis for your particular use case, you may want to consult Mixpanel's support or documentation for detailed steps tailored to your data structure and events.
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.