Report the median instead of the mean
Hi,
Would it be possible to report the median instead of the mean for the average session length?
I am seeing some weird stats due to my low sample size.
Best,
Alex
Thanks for the suggestion Alex!
I also noticed the same, and I was looking into it.
I think the problem is with users that keep a tab open for several days (eg. they go away from the PC/phone) but the session is still active, which leads to sessions having hours or even days.
I also want to maybe look further into this issue and make maybe time-out the session after a specific amount of inactivity.
I will try to implement the mean instead of the average, the main concern is performance as MySQL has an AVG function but doesn’t have a MEAN function.