I am trying to figure out how to display weekly progress on a graph, a week at a time for 12 weeks. I want the graph to display Week 1 data, then add to the data week by week. I would like to capture weekly progress for up to 12 goals at a time.
Assuming you have the week number already, and you want a rolling sum, you can use a query column for this purpose, filtering for week numbers that are less than or equal to the current week’s number, then use a rollup on top of that.
1 Like