Highlight the max expression in chart

[Anonymous]

Gud Mrng Everyone,

Today I wanted to highlight my max value in the bar chart with a different colour.

For which I had created a bar chart.

Dimension: if(Match(System_Created,'CLA','GOL','LOI','QUO','SES','BUL')

Expression : Count(GID3)-Count(DISTINCT GID3)

To highlighted Max bar, in another colour

Expression--Background Colour =If(Sum(Count(GID3)-Count(DISTINCT GID3)) = Max(Total Aggr(Sum(Count(GID3)-Count(DISTINCT GID3)),if(Match(System_Created,'CLA','GOL','LOI','QUO','SES','BUL'), RGB(245, 121,111), RGB(122,122,122)))))

Not getting the desired result, Can anyone help me Please?

[Anil_Babu_Samineni · Accepted solution]

May be this?

If((Count(GID3)-Count(DISTINCT GID3))/Count(GID3) = Max(TOTAL Aggr((Count(GID3)-Count(DISTINCT GID3))/Count(GID3),Month1)), Green())

[Anonymous]

Thanks, Anil

[passionate]

You can even try using:

if(Rank(Count(GID3)-Count(DISTINCT GID3))=1,Green())

In Background color of your expression

[Anil_Babu_Samineni]

Some cases this won't work, I've tried many times this? But good idea