Linear Gauge Color in Straight table

[#1]

Hi All,

I have a linear gauge in a straight table and the requirement is:

1. have a single segment
2. change the segment color based on an expression

The same expression is used in a text field and the colours work well but for the gauge chart the segments show only one color for each line.

The Expression is somewhat like:

=if(Sum(PASS)/(Sum(PASS)+Sum(FAIL))  > 0.85, RGB(0,128,0), RGB(255,0,0))

Please suggest if it's even possible to achieve this?

[b_garside]

You can paste it as is OR use ascii code  =Chr(219)

Alt+219 = █

http://www.asciitable.com/