Forum Discussion

AdrianoFigueire's avatar
AdrianoFigueire
Qrew Member
9 years ago

Custom Charts - Rolling Totals

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

1 Reply

Sort By
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    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?