Viewing Total Entries in Insights Report Metrics
In an Insights report, can I see not only the average but also the total number of entries for each metric?
In an Insights report, can I see not only the average but also the total number of entries for each metric?
Hi Andreas K., 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
Yes, in a Mixpanel Insights report, you can see both the average and the total number of entries for each metric. This is possible through the use of different measurements and visualizations available in Insights.
Here's how you can achieve this:
1. For the average, you can use the "Average" measurement option when setting up your metric. This is available under the "Aggregate Property" or "Aggregate Property per User" functions Docs Reports > Insights: Visualize trends and compositions within your data > Advanced > Measurements > Aggregate Property> .
2. For the total number of entries, you can use the "Total Events" measurement, which gives you the total count of events performed Docs Reports > Insights: Visualize trends and compositions within your data > Advanced > Measurements> .
3. You can display both of these metrics side by side in your Insights report by adding multiple metrics to your query.
4. To view the precise values for both metrics, you can use the Table chart visualization. Tables in Insights allow you to see multiple metrics per segment, making it easy to compare average and total values Docs Reports > Insights: Visualize trends and compositions within your data > Basic Features > Sorting> .
5. In the table view, you can sort your data by either the average or total values, depending on which metric you want to prioritize.
Remember that you can further break down these metrics using the Breakdown feature, allowing you to segment your data by various properties or cohorts Docs Reports Overview> .
By utilizing these features, you can create an Insights report that displays both the average and the total number of entries for each metric you're interested in analyzing.
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.