Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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...)