I'm using one of the events (I am measuring star reviews and breaking it down by job category). I want to show only top 5 with the best rates average and top 5 with the worst rates average, How can I do it?
Hi Monika, 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 only the top 5 job categories with the best rates average and the top 5 with the worst rates average in Mixpanel Insights, you can use a combination of the Aggregate Property measurement and sorting options. Here's how you can achieve this:1. Set up your query to measure star reviews broken down by job category.2. Use the "Aggregate Property" measurement: Select "Aggregate Property" as your measurement, then choose "Average" as the aggregation option. This will calculate the average star rating for each job category. Docs Reports > Insights: Visualize trends and compositions within your data > Advanced > Measurements > Aggregate Property> 3. Sort the results: After running the query, you can sort the results by clicking on the column header for the average star rating. Click once to sort in descending order (best rates at the top) or twice for ascending order (worst rates at the top). Docs Reports > Insights: Visualize trends and compositions within your data > Basic Features > Sorting> 4. Limit the results: To show only the top 5 categories, you can use the "View N" control in the table view. Set it to 5 to display only the top 5 results. Docs Reports > Insights: Visualize trends and compositions within your data > Basic Features > Sorting> To get both the top 5 best and worst rates, you'll need to create two separate queries or toggle between the two sorting orders.Keep in mind that Mixpanel has some limits on the number of segments that can be displayed:Docs Features > Advanced > Limits and Ordering> For Insights with a bar chart, you can select up to 300 segments, and the visible limit is 3000 segments. However, since you're only interested in the top and bottom 5, these limits shouldn't affect your analysis.If you need more flexibility or want to combine the top and bottom results in a single view, you might need to export the data and perform additional analysis outside of Mixpanel.
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.