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?

[Anonymous]

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

[prma7799]

Can you please share sample app.

[Anil_Babu_Samineni]

Do we expect any application from you to play around for BG color because you are using Calc. Dimension to do this? That would be better to help you

[Anonymous]

Hi Anil,

As said before I didn't get the option to share my application. I even shared the snapshot with you.

Yes it is true I am using Calculated Dimension: if(Match(System_Created,'CLA','GOL','LOI','QUO','SES','BUL', System_Created)

In Expression I had used : Duplicate Count

And in Back Ground Color I want: if the Duplicate count is max then change into red else colour remain same.

[Anil_Babu_Samineni]

once you reply to anyone from this thread, You will get "Use Advanced Editor" in the right corner top of your body message. Then bottom you will get "Attach". There you can and "Add Reply" then we can easy to access

[Anonymous]

I have click on reply button still I didn't get the Advance Editor button.

[Anil_Babu_Samineni]

Uploading a Sample

[Anonymous]

Please find the required app

[Anonymous]

Please don't share the app as I am not using a licence version.

Just need the Expression that I would use in Background Colour of Expression.