color code expresion for dimenstion?

[daisy1438]

Hi

I have field A1Control.uisng this A1control field as a dimension. in that dimension having  Ineffective. Needs Improvement and Effective.

in chart effective gray color and need improvement amber color and ineffective red color.

what is the expression in color tab for getting above requirement.

Thanks.

[justinphamvn]

Hi,

You can use Color by Dimension value

Hope this helps,

Justin.

[Ivan_Bozov]

Try this:

IF(A1Control='Ineffective', RED(),

IF(A1Control='Needs Improvement', RGB(255,128,0),

LIGHTGRAY()))