RangeSum with 2 dimensions does not work

SilviyaK — Tue, 28 Jan 2025 18:10:32 GMT

Hi all,

I have a bar chart where I have the following two dimensions:

Month

ScoreType

and a Measure:

count(ContactID)

I need to see this as a stacked bar chart and cumulative. If I use the below expression and only the Month dimension, the chart is showing accumulated values:

RangeSum(above(count(ContactID), 0, rowno()))

The moment I add the ScoreType back though, it doesn't work anymore, it is not cumulative anymore and it shows incorrect numbers.

I tried all kinds of aggregations but they also seem to be not working at all (few examples below):

RangeSum(above(sum(aggr(count(ContactID),Month,ScoreType)), 0, rowno()))

RangeSum(above(sum(aggr(count(ContactID),Month,ScoreType)), 0, rowno(total)))

sum(aggr(RangeSum(above(count(ContactID), 0, rowno(total))),Month,ScoreType))

Could you please help? Thanks!

Re: RangeSum with 2 dimensions does not work

MatheusC — Tue, 28 Jan 2025 20:53:39 GMT

maybe like this:

Aggr(RangeSum(Above(count(ContactID), 0, RowNo())),ScoreType, (Month, (Desc)))

- Regards, Matheus

Re: RangeSum with 2 dimensions does not work

marcus_sommer — Wed, 29 Jan 2025 06:28:24 GMT

You may try: RangeSum(above(TOTAL count(ContactID), 0, rowno()))

topic Re: RangeSum with 2 dimensions does not work in App Development

RangeSum with 2 dimensions does not work

Re: RangeSum with 2 dimensions does not work

Re: RangeSum with 2 dimensions does not work