Replacing text with icons (colored led)

[#1]

Hi there,

I have several table boxes

I have a status column which is On time / Late / At risk

I would like to replace the text with some icons, for exemple colored leds (green = On Time / Red = Late /  At Risk = Yellow)

What should I do in order to implement this ?

Regards,

[Gysbert_Wassenaar · Accepted solution]

Something like this:

pick(match(Status,'On time','Late','At risk'),'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png','qmem://<bundled>/BuiltIn/led_o.png')

You can select the builtin images on the Images tab of the expression editor.

[#3]

Thanks for the quick reply, but I don't know where to put that expression....

Which tab from my table box properties ?

[Gysbert_Wassenaar]

You can't put it in a table box, you'll have to use a straight table or pivot table and add it as an expression or calculated dimension.

[#5]

Thanks it worked