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?

[#2 · Accepted solution]

color not recalculated for your dimention (like using $() ).

just use background color of table cell(expression) and transperent gauge

[jonathandienst]

Hi

Not sure what you are trying to achieve. Each segment can have a separate colour, but with a single segment, the bar can only display one colour.

Jonathan

[Gysbert_Wassenaar]

See attached qvw for another option.

[#5]

LOL nice try =)))

[#6]

Thanks Gysbert,

I am trying to achieve the same with a Gauge Chart but I guess the color calculation does not work in the same way as it does not allow calculating colors based on the dimension but the color calculation does not consider the dimension.

@ Jonathan: I am only trying to get a single color but based on the expression change the color for the gauge. Please refer to the attached image, the text field shows green where the % is greater than 85 else red. I want the same for the Gauge color:

[#7]

Sem,

I guess your solution works as the workaround and I can live with that

[#8]

glad to help

[b_garside]

I've been trying to do the exact same thing. Not sure I understand "just use background color of table cell(expression) and transparent gauge"   any ideas how making the background transparent will help?

Wish there was a sample of this

[jim_chan]

hi there, where can i find this icon?    '█' ???

Rgds

Jim