Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You can use Color by Dimension value
Hope this helps,
Justin.
Try this:
IF(A1Control='Ineffective', RED(),
IF(A1Control='Needs Improvement', RGB(255,128,0),
LIGHTGRAY()))