Cumulative average Month by month

Anonymous — Mon, 16 Jul 2018 22:09:47 GMT

Hi community.

I am trying to generate an accumulated average month by month.

This way it works:

But I need to show the data in this visualization, but the result is different

This is the expression that I am using:

RangeSum(above(sum(CustomerSpend),0,rowno()))/RangeSum(above(sum([Customer Count]),0,rowno()))

I try to show the same information in both graphs, but when changing the type of table it is calculated different.

Re: Cumulative average Month by month

petter — Mon, 16 Jul 2018 23:01:57 GMT

Above() might have to change to Before()....