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:
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.