Question

How to plot "Average Time Spent in Min" per user?

  • 3 December 2020
  • 3 replies
  • 91 views

I am currently doing the following (please see attachment).

 

Is the right way of doing it? Or is there a better way? How do I calculate median time spent in min per user?


3 replies

Hey dshrenik,

Another way of doing this is using the event “Session End” that holds the property “Session Duration (Seconds)”. Then you could easily also sort by median, max/min, X% percentile etc. :) 

Note that the property holds seconds, so getting minutes you’d need to do as you’ve done above and dividing it by 60 using “formulas”.

Good luck!

 

I can also recommend “Distribution” if  you haven’t seen it, pretty neat to see the time spent in-app distributed in a customisable range, e.g. in groups of 5 minutes (or whatever that’s relevant for you). 

Userlevel 6
Badge +3

@filiptideman 

Great responses! Thank you so much for taking the time to help out other users in QBQ. This is SUPER helpful. 

Reply


Mixpanel