Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
Did you try chart accumulation property? Looks like it does what is shown as expected output above.
Did you try chart accumulation property? Looks like it does what is shown as expected output above.