Accumulated month sum by groups: Chart for rangesum(above(Sum(Unit), 0, RowNo()))

nezuko_kamado — Mon, 31 Jan 2022 20:01:12 GMT

I could create a pivot table of monthly accumulated unit sum with rangesum(above(Sum(Unit), 0, RowNo()))

This chart is what I want to get of the grouped by Month with the accumulated unit sum over months, just like the highlighted part.

However, I can’t visualize the highlighted part with a bar chart or a combo chart, and I manually had to sum the total of each month as below in order to create the graph above.

AccumulatedMonthSum:
Load * inline [ Year, Month, AccumulatedSum
2019,        Jan            ,14
2019,        Feb            ,27
2019,        Mar           ,44
2020,        Jan            ,13
2020,        Feb            ,32
2020,        Mar           ,40
2021,        Jan            ,17
2021,        Feb            ,24
2021,        Mar           ,32
2022,        Jan            ,18
2022,        Feb            ,37
2022,        Mar           ,47];

Without this manual summation, all I could get were as below, which are different from the top graph .

How can I create the graph on top without manually calculating the sums?

I tested them with a pseudo data set below, since my original is too large and complicated.

Dat:
load * inline [ Year, Month, Unit
2019, Jan, 2
2019, Jan, 3
2019, Jan, 4
2019, Jan, 5
2019, Feb, 2
2019, Feb, 2
2019, Feb, 1
2019, Feb, 3
2019, Feb, 5
2019, Mar, 6
2019, Mar, 4
2019, Mar, 2
2019, Mar, 5
2020, Jan, 6
2020, Jan, 2
2020, Jan, 2
2020, Jan, 3
2020, Feb, 3
2020, Feb, 4
2020, Feb, 5
2020, Feb, 6
2020, Feb, 1
2020, Mar, 1
2020, Mar, 2
2020, Mar, 2
2020, Mar, 3
2021, Jan, 3
2021, Jan, 4
2021, Jan, 5
2021, Jan, 5
2021, Feb, 2
2021, Feb, 2
2021, Feb, 1
2021, Feb, 2
2021, Mar, 4
2021, Mar, 3
2021, Mar, 1
2022, Jan, 1
2022, Jan, 4
2022, Jan, 6
2022, Jan, 7
2022, Feb, 3
2022, Feb, 7
2022, Feb, 5
2022, Feb, 4
2022, Mar, 2
2022, Mar, 3
2022, Mar, 5
];

Re: Accumulated month sum by groups: Chart for rangesum(above(Sum(Unit), 0, RowNo()))

Digvijay_Singh — Mon, 31 Jan 2022 23:43:17 GMT

Did you try chart accumulation property? Looks like it does what is shown as expected output above.

topic Re: Accumulated month sum by groups: Chart for rangesum(above(Sum(Unit), 0, RowNo())) in App Development

Accumulated month sum by groups: Chart for rangesum(above(Sum(Unit), 0, RowNo()))

Re: Accumulated month sum by groups: Chart for rangesum(above(Sum(Unit), 0, RowNo()))