topic Re: Cumulative total for relative value in App Development

Cumulative total for relative value

lord_zeus — Sat, 16 Nov 2024 19:15:23 GMT

Hello, everybody!

Im try to calculate a relative value for chart visualisation where dimantion in days spend (0,1,2 etc)

Problem: in component of formula i need a cumulative total by my dimantion.

I'm make some example:

Im wont get chart like this

the problem is that I cannot use the previous values for the calculation. I need to take a measurement and count less than the current in a variable or in SetAnalysis

Re: Cumulative total for relative value

Kushal_Chawda — Wed, 22 Jan 2020 16:54:30 GMT

may be this

=(rangesum(above(total sum({<ID>}OUT),0,RowNo(total)))/rangesum(above(total sum({<ID>}IN),0,RowNo(total))))*avg(1)

Where ID is the X-axis Dimension

Re: Cumulative total for relative value

lord_zeus — Thu, 23 Jan 2020 11:18:24 GMT

Thenks, its work.

Im make a reference table and add it to model with references to main table. Im need it becose my formula with count(distinct id) ... so im need to calculate unicu id in each row...