Calculating Average Rating Value for Star Rating Event
Suppose I have an event named Star rating submitted which has a property saying rating value the value could be 1 to 5 now for this event i want avg rating value
Hi Raviraj, 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 average rating value for your "Star rating submitted" event in Mixpanel, you can use the "Aggregate Property" measurement in the Insights report. Here's how you can do it:1. In Mixpanel Insights, select your "Star rating submitted" event. 2. For the measurement, choose "Aggregate Property" from the dropdown menu. 3. Select "Average" as the aggregation type. 4. Choose the "rating value" property.This will give you the average rating value across all instances of the "Star rating submitted" event.Here's a relevant excerpt from the Mixpanel documentation:Aggregate Property:> | Function Name | Events Calculation |
| --- | --- | | Average | Average of a numeric property value across all instances of [event].Example: What's the average number of minutes per video watched? |This method will calculate the average rating value for your event, giving you insights into the overall user satisfaction based on the star ratings submitted.
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.