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

  • 3 December 2020
  • 3 replies

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


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