Distinguish Dimension in a Cumulative Bar Chart

[BoXiangWang]

Hi

I have a cumulative bar chat and there are two dimensions in my dataset.

I used this expression to get the result, but I don't know how to distinguish the two dimensions in a month.

=RangeSum(Above(TOTAL Count(id), 0, RowNo(TOTAL)))

For instance, in 2024-Sep, there are like 1,000 as actual and 1,173 as plan. How can I separate them in color coding? I had tried to use the "By dimension" in the "Colors and legend", but didn't work. The system directly make the months with "plan", which are from Sep to Dec, as whole red.

Btw, the dimension name is "Type" for reference.

Thank you for any advice.

[lennart_mo]

Hi @BoXiangWang,

Have you tried to achievie this with a stacked bar chart? There you could use 2 measures, one counting the actual ids and one counting the planned. To these measures you could easily apply seperate colors.

=RangeSum({<Type={'actual'}>}Above(TOTAL Count(id), 0, RowNo(TOTAL)))

and

=RangeSum({<Type={'plan'}>}Above(TOTAL Count(id), 0, RowNo(TOTAL)))

would be something i could imagine to work in your case.