Question on Chart background color

[ramanarayan]

Hi QV Experts,

I am finding it hard to get the color coding to work in one of the charts that i built. The background color does not seem to behave the same way how i wrote the expression for the background color. The colors are not in sync with the color expression.

Any reason for this behaviour?

Attached is my chart screen shot.

My chart should ideally reflect, RED, Blue, Yellow and Green color legends.

Thanks,

Ram

[Clever_Anjos]

Could you post your background color expression?

Easier to find out what is going wrong

[ramanarayan]

Thanks Clever Anjos for responding. Here is the expression.

=if(UTK_Fill_Rate='0 %',LightRed(),

if(UTK_Fill_Rate > 90/100,LightGreen(),

if(UTK_Fill_Rate < 80/100,Yellow(),RGB (0,150,214))))

[Clever_Anjos]

And which expression you have?

[ramanarayan]

The expression that i have at a chart level is the following

=count([FRCA_Fill Rate Category])

but the color coding is decided by another field. Is that the problem?    

[Anil_Babu_Samineni]

If possible please share mockup application to test

[Clever_Anjos]

Try with

if (

     count([FRCA_Fill Rate Category]) / count( total [FRCA_Fill Rate Category]) > 0.9, LightGreen(),

if (

     count([FRCA_Fill Rate Category]) / count( total [FRCA_Fill Rate Category]) > 0.8, Yellow(),

RGB (0,150,214)

))

please make your adjustements