Discussions

Expand all | Collapse all

Custom Charts - Rolling Totals

  • 1.  Custom Charts - Rolling Totals

    Posted 04-12-2017 12:14
    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


  • 2.  RE: Custom Charts - Rolling Totals

    Posted 04-16-2017 05:35
    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?