Custom Charts - Rolling Totals

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
Custom Charts - Rolling Totals. Any insights please on how to create a chart that plots the rolling total for a time series? I have a summary report that has day of year on rolls and running total for a given year on columns. Is there a way to plot those on a chart? Thank you
Photo of Adriano Figueiredo

Adriano Figueiredo

  • 40 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
To get this cumulative data in a report you will need to do a few things.

You will need to take a snapshot of the data and summarize it into some table, then use that table to be compared to a month or week table (depending on how you want to group things.

Basically do do this without any script it would take a decent amount of work to get the data flowing the right way.

Do you have more info about your use case or an example report that you are currently using?