topic Re: Running sum in a Stacked Bar Chart in App Development

Running sum in a Stacked Bar Chart

Stevan_Klaas — Fri, 15 Nov 2024 23:43:17 GMT

Dear Community,

I am trying to produce a stacked bar chart with a cumulative sum across dates with the customers being the groups :

This is the base data :

In Excel obtaining the underlying table is easily done with pivot running sum on "Booking Year Month" :

However I can't find a use case in the community that does the trick.

Below is the nearest solution I found, it cumulates when there is a data at the intersection of dimensions but it doesn't persist the cumulated amount across the data columns.

Thanks for any help,

Stevan

Re: Running sum in a Stacked Bar Chart

Stevan_Klaas — Sat, 25 Sep 2021 17:01:30 GMT

Found the solution myself :

In the measure properties of the bar chart, use the modifier "Accumulation", but make sure that you :

1 - cumulate accros the X-Axis dimension

2 - Set the range to "full" !!

(Strangely by default the range is "Custom" with 6 steps, which would do a rolling accumulation over 6 axis values...)

Re: Running sum in a Stacked Bar Chart

Andrei_Faibich — Thu, 25 Jan 2024 23:01:30 GMT

I tried to repeat your solution using the dataset provided and I didn't succeed.

The only solution I found is to restore missed dimension values for each Customer with dummy Sales