How to Calculate Average Session Duration Correctly in Mixpanel
I can't figure out how to calculate the Average Session Duration per SESSION (Total Session Time / Total Sessions), not the average duration per USER. For example, it's giving around 7 minutes per multiple sessions a user has had, instead of ~1 minute per session. The Mixpanel UI consistently defaults the metric aggregation to 'Aggregate Property per User' or a 'User Sum' calculation, even when I select 'Average' of the 'Session Duration' property. When I try to use a Formula Metric (A/B), my numerator (Metric A) is being defined as User Sum of Session Duration (as seen in the formula definition) instead of a simple Sum of Session Duration across all events. This results in an incorrect, inflated average.
