Lloyd N.

OMG! Yes. that worked. Thanks

this is what i see now:

Ansh A. I'm so sorry, but I just can't figure this out. Where should I be to calculate the unique days, months, etc? I can only find 'time' in the filter that filters the total events by a time period but I can't insert it like a time metric where i can use it in a formula as a denominator.

Ansh A. Thanks for your suggestion. That would definitely resolve this but I can't figure out how to create unique days. Since time is only a property, I don't think I can create a metric giving me just the count of unique days.

Could our average session duration (~6 minutes) be inflated compared to Google Analytics (1 minute) due to the inclusion of server-side or system-level events that are stretching the duration between the first and last event, but are not actual user interactions? If so, what event property is the most reliable way to filter a session query to include only client-side, user-driven events (excluding server-side, internal, or bot activity)? Is it $source, $device_type, or another property?

30 minutes does seem reasonable -- and similar to GA -- so I'm not sure that's it.

Thank you! I think this works, but my avg session time is significantly higher than my google analytics avg session time. ~6 mins vs ~ 1min. Might this be because it is defining session duration differently. What is the default session timeout value in Mixpanel and where can I find it/configure it?

Note that my goal is to get an avg per session duration similar to what google analytics provides as a default statistic.