I have been having a hard time working out a solution to getting the median session duration. The average duration is a standard metric and MEDIAN() doesn’t accept aggregated data. How can I create a calculated metric or use another method to get the median session duration for the selected time period?
I might be missing something, but why do you need to apply a median to the average?
Can you apply the median to the field that the average is applying to?
1 Like