Is it possible to sum by interval?
I'm attempting to create a Pie chart which reflects the time various users spend in different states. I want to be able to analyse over various time periods from months down to days. Currently the time period is in minutes, which becomes rather inconvenient when looking at longer time periods.
I've managed to turn the time in minutes into an interval of hh:mm:ss but after doing so find that the Pie chart won't sum the results. Is there any way to sum an interval to make it usable on graphs or pivots?