Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my Line Chart, I have a calculation to create a Cumulative % as the months proceed. It works for aStraight Table that I put the code in, but I'm guessing because of the RangeSum or Above functions, it is affecting the chart. Here is the calc being used in my straight table/Line chart and the data...
-If I have one ID selected it shows the smooth curve (ex. 1), then when I select multiple IDs I get dips in the curve (ex. 2) which shouldn't happen in a cumulative setting. I'm trying to get a cumulative of % over the months by each ID, the curve for the line should remain static.... Thoughts?
Ex.1
Ex. 2
I fixed it by using the incremental formula I was using and checking the "Full Accumulation" option under Accumulation in the Expressions tab.
@MalcolmCICWF try below
= sum(aggr(Rangesum(above(total sum({<YourDimension>}PaymentAmount)/sum({<YourDimension>}FaceValue),0, rowno(total))), (YourDimesion,(NUMERIC,ASCENDING))))
Hi @MalcolmCICWF , did you try using before() instead above()?
@QFabian Before function is designed to work for pivot table only.
That one didn't work as soon as there are multiple IDs selected.
ok so let me ask you this... In one expression I am using sum(PaymentAmount)/sum(FaceValue) to get the incremental % each month. Can I use this expression combine with the Before function in a Line Chart to get a cumulative? All I'm really looking for is to instead of getting incremental each month, get the cumulative as the months go on... so adding in the previous month's % as each month goes on. You can see this in the straight table I provide.
I fixed it by using the incremental formula I was using and checking the "Full Accumulation" option under Accumulation in the Expressions tab.