Displaying Percentages in Pie Reports: Chart Format Changes Explained
how to show percentages in the Pie report instead of the number? or how do I change the chart format for it
Hi Juan I., 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 show percentages in the Pie chart instead of numbers in Mixpanel's Insights report, you can use the "Percentage of Overall" comparison option. Here's how to do it: 1. Create your Insights report with the data you want to visualize in a Pie chart. 2. Change the chart type to Pie chart if it's not already selected. 3. Open the "Compare" menu. 4. Select "Percentage of Overall" from the options.This will display the data as percentages of the total instead of absolute numbers.For more details on this feature, you can refer to the Mixpanel documentation on Comparison: Time, Baseline and Overall.Note that the "Percentage of Overall" option allows you to see how segments perform as a percentage of the total. Mixpanel will automatically disable this option if it won't give meaningful results for your specific data configuration.If you're looking to change the chart format in general, you can select different chart types in Insights. The Pie chart is one of several available visualizations, including line charts, bar charts, and others. You can choose the most appropriate chart type for your data by selecting it from the chart type options in the Insights report interface.
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.
Juan I.··it says "chart comparison is not available for pie charts" and I cant select the option youretelling me
Let me check the knowledge base for you again. One moment! đź“š
I apologize for the confusion in my previous response. You're right, and thank you for pointing that out. It appears that the information I provided earlier was not accurate for Pie charts specifically. Let me clarify based on the most up-to-date information from the knowledge sources: According to the Mixpanel documentation on Supported Charts, Pie charts have the following comparison support: | Chart Type | Time Comparison Supported | Percentage change over Baseline Supported | Percentage of Overall Supported | | --- | --- | --- | --- | | Insights Pie | No | No | Yes |While the "Percentage of Overall" is listed as supported for Pie charts, you're encountering an error message that suggests this feature might not be available or might have changed.Given that you're unable to select the option I mentioned earlier, and you're seeing a message that "chart comparison is not available for pie charts," it seems that the current implementation of Pie charts in Mixpanel doesn't support the comparison features as previously documented.In this case, I recommend reaching out to Mixpanel's support team for the most up-to-date information on how to display percentages in Pie charts, as the knowledge sources provided don't contain enough information to resolve this discrepancy or provide an alternative solution.I apologize again for any confusion caused by my previous response. Thank you for bringing this to my attention, as it helps improve the accuracy of the information provided.
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! đź“š
To see averages of Unique Users for an event using the Table graph in Mixpanel Insights, you can follow these steps: 1. Create a new Insights report and select your desired event. 2. Change the chart type to "Table" from the visualization options. 3. In the metric selection, choose "Unique Users" as your measurement. 4. To get the average, you'll need to use the "Aggregate Property" measurement with the "Average" function.Here's how to set it up specifically: 1. In the metric selection, click on "Unique Users" to open the measurement options. 2. Select "Aggregate Property" from the dropdown menu. 3. Choose "Average" as the aggregation function. 4. Select the property you want to average (if applicable).This setup will give you the average of Unique Users for your selected event in the Table graph.It's worth noting that Mixpanel offers various aggregation options for different metrics. According to the Mixpanel documentation on Measurements, when you select "Aggregate Property," you have several aggregation options including Sum, Average, Median, Distinct Count, Percentiles, Minimum, and Maximum.If you need more detailed information or encounter any issues, I recommend checking the full Mixpanel documentation or reaching out to their support team for the most up-to-date guidance.
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! đź“š
I apologize, but the knowledge sources provided don't contain specific information about defining the calculation for Overall totals in Mixpanel tables. However, I can provide some related information that might be helpful: According to the Mixpanel documentation on Sorting in Insights, tables in Insights include Overall and Segment Sub-Totals: "Overall: This refers to the value considering all the segments, independent of whether displayed or not based on your View N control; i.e changes to View N will not affect Overall numbers""Sub-Totals: In the grouped view, in addition to the Overall, segment sub-totals are also displayed. Similar to "Overall", these values are independent of the View N control"This suggests that the Overall total is calculated based on all segments, regardless of what's currently displayed in the table. However, the documentation doesn't provide information on how to customize or define this calculation.For more specific information about defining calculations for Overall totals in tables, I recommend reaching out to Mixpanel's support team directly. They would be able to provide the most up-to-date and accurate information about this feature, especially if it's a recent addition or if there are specific settings available that aren't covered in the provided documentation.
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.
Ina G.··Hi Juan, did you manage to see % percentages for pie charts?
- Juan I.··
No actually. Did you?
- Ina G.··
nope, same here. just changed the chart type - switched to bar chart and then accessed from "Compare" the "Overall" for percentage.
- Juan I.··
right ... thats the way to do it without a Pie chat
- Juan I.··
chart