How to use color() in the express

[#1]

@sunny Talwar

Hi All,

    I want to add color () to the expression below, how do I go about it ?

IF([EXPERIENCE_RATING]=1,'NEGATIVE',

IF(([EXPERIENCE_RATING]=2 OR EXPERIENCE_RATING = 3),'NEUTRAL','POSITIVE'))

I want the bar chart to turn RED when it NEGATIVE, AMBER when it is NEUTRAL and GREEN when it is POSITIVE.

Thanks

[daniel_kusiak · Accepted solution]

Hi,

Change the background definition of your chart expression to:

IF(EXPERIENCE_RATING=1,Red(),IF(EXPERIENCE_RATING=2,Yellow(),Green()))

It should look like this:

If you want different colors use RGB function.

[#3]

Thanks Daniel!!