How to chage the colour of guage chart based on condition?

[#1]

Hi,

I have a gauge chart with below expression:

Avg(CaseStats)

the value of Avg(CaseStats) has 243. I have to write a condition to show the values as in green colour if Average <90 it should show green and the values above 90 should show Red

how can I change the expression can anyone help me please?

Thanks.

[#2]

please see attached as this is today value 243 and based on my condition it should show the colour as red

[SunilChauhan]

go to chart properties

uncheck autowidth segment if not

-> presentation change the colour of segment 1 and segment 2

hope this helps

[SunilChauhan]

see the attched image for refrence

[#5]

Thanks. Sorry I know this place to change. I need the expression to meet the condition. Please help.

[SunilChauhan]

in segment 2 text box you can write 90

[SunilChauhan · Accepted solution]

[#8]

Thanks. for me it is not allowing. how can I change?

[#9]

Uncheck the Autowidth segments option on the lower left corner on the Presentation tab.

[Anonymous]

Hi,

You can set % value in the segment. For example, if you want to set value for Average <90 then first you have to convert it into %. Something like below,

90/Avg(CaseStats)