Stacked Bar Chart uneven colours

[infock12]

Hi All,

I am creating two stacked bar charts (please see attached). I have given the below variables for colours under Expressions > Background Colour.

=if([Rating]>12, RGB(255, 0, 0),
if([Rating] >=8 and [Rating] <=12, RGB(255, 153, 0), RGB(255, 255, 0))

The colours are all over the place. It is working in some bars and not working in others, which is strange. For example, if you select "CFN" under Response list box, it works fine (1 yellow, 1 amber, 1 red). However, if you select "Doc", in spite of giving the right values on the bars, there is a same colour. There seems to be something very simple that is wrong. Please help.

Thanks,

Karthik

[kji · Accepted solution]

Try using Avg(Rating) instead of just rating.

Also "and [Rating] <=12" is superfluous since you already got rid of the with the first if.

[infock12]

Hi Jodan,

Thanks for the quick reply. I tried

=if(Avg([Risk Rating])>12, vRed,
if(Avg([Risk Rating])>=8, vAmber, vGreen))

and it worked!!