Skip to main content
Question

Custom Charts - Rolling Totals

  • April 12, 2017
  • 0 replies
  • 19 views
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
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • April 16, 2017
      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?
      Terms & ConditionsAccessibility statement