topic Re: Unique Color for Maximum value in Stacked Bar chart in App Development

Unique Color for Maximum value in Stacked Bar chart

Karthick30 — Wed, 22 Jun 2022 15:12:33 GMT

Hi ,

I have a Stacked Bar chart like below.

for past 3 years , each month value has been taken here. Now I have the Requirement to show max values in separate colour for each month.

For Ex.. Apr , 34176 is the Max value out of remaining 2 years value. So i need to color that alone in unique colour.

Likewise , each month max value for one particular year has to be in same unique color. Any logic to achieve that?

Re: Unique Color for Maximum value in Stacked Bar chart

edwin — Wed, 22 Jun 2022 16:00:51 GMT

there are two components to your problem:
1. find the max per year
2. set the color

to get the max:
aggr(nodistinct max(aggr(nodistinct sum(Measure), Month, Year)), Month)

to set the color:
in yor chart, set color to expression:
if(sum(Measure)=aggr(nodistinct max(aggr(nodistinct sum(Measure), Month, Year)), Month),red(),
here your expression for the color by year
)

here is a sample run. this one. the first doe snot look at max and the colors are:
pick(match(ThisYear,2019,2020,2021,2022),blue(), green(), Yellow(), Black())

now if i add the logic for max:
the max became red:

Re: Unique Color for Maximum value in Stacked Bar chart

Karthick30 — Wed, 22 Jun 2022 18:28:46 GMT

Thanks @edwin