RANGESUM - ABOVE - Not working when a new dimension added to chart

sibijoseph — Sat, 16 Nov 2024 06:12:57 GMT

Hello All,

I'm using the following expression to obtain a cumulative chart:

RangeSum(Above(num(Count({<ORDER_STATUS = {'COMPLETED'}>}ORDER_NUMBER)/(Count(total ORDER_NUMBER))),
0, RowNo(total)))

This is created as Measure (Height).

Under dimensions I have one dimension which is basically - NUMBER OF DAYS. Please find below screenshots. This is working as expected, no issues.

WorkingAsExpected

--------------------------

But now I want to add another dimension CREATION_WEEK, so that I can select multiple weeks and do the comparison.

So I went ahead with the same expression as above -

RangeSum(Above(num(Count({<ORDER_STATUS = {'COMPLETED'}>}ORDER_NUMBER)/(Count(total ORDER_NUMBER))),
0, RowNo(total)))

And added one more dimension - CREATION_WEEK in addition to NUMBER OF DAYS, but now the chart is not displayed as expected. Please find below screenshots.

I tried using Aggr() function but not successful. (I'm not sure on how to use it)

So I'm looking forward for suggestions to do this cumulative sum as done in the first chart but on a weekly basis so that I could select required weeks and do comparison.

Let me know if something is not clear!

Re: RANGESUM - ABOVE - Not working when a new dimension added to chart

tresB — Fri, 29 Mar 2019 09:42:29 GMT

Try putting Total in above(), like:

RangeSum(Above(Total num(........

Re: RANGESUM - ABOVE - Not working when a new dimension added to chart

sibijoseph — Fri, 29 Mar 2019 09:47:27 GMT

That's cool! Worked.

Solved

topic Re: RANGESUM - ABOVE - Not working when a new dimension added to chart in App Development

RANGESUM - ABOVE - Not working when a new dimension added to chart

Re: RANGESUM - ABOVE - Not working when a new dimension added to chart

Re: RANGESUM - ABOVE - Not working when a new dimension added to chart