I’ve created a calculated field for session time by doing this:
Which gives me what I would expect when plotted over the last 30 days:
You’ll notice that the max is 13.9 and the min is 1.8 and looking at the chart the average is probably in the region of 7 or 8 minutes.
However, when I change this to a table:
I get an *average* of nearly 31 mins.
So have I done something wrong? How can I get a 30-day average session time (that’s all I need to go on a dashboard)? Or, is it a bug?