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?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hey Josh L ,

    Thanks for writing in and apologies for the delayed response. While this currently isn't possible in Mode, this can be achieve by using calculated fields, which are coming to Mode soon!

    Like
Like Follow
  • 11 days agoLast active
  • 1Replies
  • 294Views
  • 2 Following