Guidance Needed on Calculating Total Session Duration Per User

·Dec 31, 2025 06:16 AM·

Hi guys, I'm stuck at this particular question. If I need to calculate total session duration PER user PER day, I know I have to use 'Aggregate Property per User' but I'm confused on which options to choose? first aggregation: sum, average, distribution, median, percentile, min, max second aggregation (on choosing sum): average, distinct count, min, max I know the 'Session Durations' property is to be used after this, just confused on exactly which aggs to choose? I went through the documentations but still don't understand

4 comments

· Sorted by Oldest

Mixpanel Community
APP
·
·
This post is now synced! Check it out here:
Guidance Needed on Calculating Total Session Duration Per User
⤵️ Any future comments will be automatically posted to the thread
Mixpanel Community
APP
·
·
Thanks for your question! Hopefully, your peers in the community can help answer your questions. However, if you need some review from our Support team, leave 🎫 on your question and we should reach out shortly! If you do this, please make sure to not send duplicate tickets through the Support webform. Appreciate it! In the meantime, let us know if this feedback is similar to any previous discussions below:
1.
Tips for Calculating User Time Spent on Online Courses (1 year ago)
2.
How to Calculate Average Session Duration Correctly in Mixpanel (5 months ago)
3.
Counting Distinct Parameter IDs Per Session in Mixpanel (9 months ago)
4.
Creating a User Session Time Report for Web Pages (1 year ago)
5.
Breaking Down Average User Engagement by Duration Intervals (9 months ago)
Ansh A.
·
·
Rinitha R. You should do average first, and then sum. It would then first calculate the sum of duration for that user on that day, and then get the average of all users's sum
Rinitha R.
·
·
Thank you!