Calculated color for a led gauge in a table

[#1]

hi all,

I made a table with one expression showed as a led gauge.
The gauge calculates just fine, so for each line in the table the led gauge shows a number.

Now i'm trying to make the color of the led calculated depending on the value on that row but if i use the same formula in de color as in the table it uses the overall value instead of the value on the line..
The formula i use is, the color should be red if < 33%, orange if < 67% and else green:

num

((count({$<JobTijdigafgerond = {'Op tijd afgerond'},JobFinishYear = {$(#v_HUIDIGJAAR)}>} Distinct JobId)/ count({$<JobFinishYear = {$(#v_HUIDIGJAAR)}>}distinct JobId)),'00%')

The image below shows my table, the overall number is 29, and now all led signs are red, i wanted the second row (56) to be orange, is that possible?

thanx!

david

[#2]

pls. add your and i'll try to help u

[pover · Accepted solution]

I don't think this is posible since the color is calculated before the expression is sliced by the dimension. You could change the color of the background and make the LED white.

In general LEDs are hard to read, unnecessary and remind be of my alarm clock. It would be easier on you and the end user if you use normal text.

Regards.

[johnw]

Karl Pover wrote:In general LEDs are hard to read, unnecessary and remind be of my alarm clock. It would be easier on you and the end user if you use normal text.

This.

[#5]

thanx all for your advice and help, i made it tekst and now it works fine...