RangeSum with 2 dimensions does not work

[SilviyaK]

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!

[MatheusC]

maybe like this:

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

- Regards, Matheus

[marcus_sommer]

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