topic cumulative sum line chart in App Development

cumulative sum line chart

MZqlik — Fri, 23 Sep 2022 11:10:51 GMT

Hi There,
I am having some trouble making this to work.

I want to create a line chart which shows the incremental increase by month of the same amount.

This is the set analysis --> =(COUNT(DISTINCT UIN)*vTargetKPI1 )/12
vTargetKPI1 is a fixed number (2.99)

What formula should I use to achieve that? I tried rangesum(above(sum(vTargetKPI3/12)),0,rowno())) but it's not working as expected.

The result of the above set analysis is 20.43 (April 2021) so I'd like to go up to May +20.43 so 40.86 June +20.43 =61.29 and so on.

Thank you for helping!

Re: cumulative sum line chart

sidhiq91 — Fri, 23 Sep 2022 11:56:33 GMT

@MZqlik Could you please provide some sample data?

The expression that you have shown above should have ideally worked.

Re: cumulative sum line chart

MZqlik — Fri, 23 Sep 2022 12:09:53 GMT

UIN are just a number which identifies one person. ex 100256 100658 etc
I don't use anything else on this one. It is very odd.