Calculating Average Rating Value for Star Rating Event

Raviraj · 2024-11-12T15:10:23.269125+00:00

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

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.

2 comments