Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have a line chart with multiple measures as below illustrated, which all starts since 0 in Y axis direction, with some are overlapped not good to see. Is it possible to stack one measure on another in line, with the two lines gap being the new measure result, and accumulative so on in Y axis diection with further measures?
Having tried to use above() and rangesum(), but not very understanding their concept on this case, kindly please advise. thanks
if u want to accumulate ur expression:
u change it from:
sum(Measure)
to
rangesum(above(
sum(Measure)
,0,rowno()))
Now, if u have 2 dimensions as in ur case (dim1 and dim2)
u have to Aggregate by dim2 then dim1:
Aggr(
rangesum(above(
sum(Measure)
,0,rowno()))
,dim2,dim1)
Under presentation: