Setting background colours in a table for multiple target values

[ToinkToinkTigger]

Hello everyone,

We have several production lines (left column) in our factory.  See the table below.

Each production line has its own target values in the columns TEEP%, OEE%, Utilization%, Availability% and Performance %.

I am looking for a line of code where the values in the table will colour red for TEEP, Utilization, OEE, Availability and Performance when below a certain threshold value. The tricky part is that each line has its own target values.

Would appreciate some help on how to achieve this 🙂

Regards,

[rubenmarin]

Hi, I think you will need to load those objetives associated to each line (maybe also line-year) so you can compare this field value to your epxression to set the color.

This can be a new data model table with a row for each [Production Line] and a field for each objective (TEEP, OEE...)