Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure reliability based on number fo events

I have a table that show failure in a line production I need to create a formular to measure reliability based on the number of events of a specific station like this If number of events <50 Hig...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello @EC3 ,

    Try the SWITCH() function.

    Reliability =
SWITCH (
    TRUE (),
    Actuators[Events] < 50, "High Efficiency",
    Actuators[Events] >= 50
        && Actuators[Events] < 75, "Regular Efficiency",
    Actuators[Events] >= 75
        && Actuators[Events] < 99, "Medium Efficiency",
    Actuators[Events] >= 99
        && Actuators[Events] < 140, "Low Efficiency",
    Actuators[Events] >= 140, "Very Low Efficiency"
)

    Best regards

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Im using this formula that

Reliability - IF(
Actuators[Events] <50,"High Efficiency",
IF(AND(Actuators[Events] > 50,Actuators[Events] <75),"Regular Efficiency",
IF(AND(Actuators[Events] > TM 75, Actuators[Events] <99),"Medium Efficiency",
IF(AND(Actuators[Events] > TM 99, Actuators[Events] <140),"Low Efficiency",
IF(Actuators[Events] >140,"Very Low Efficiency")))))

But the result isn't correct

Captura.PNG



Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello @EC3 ,

Try the SWITCH() function.

Reliability =
SWITCH (
    TRUE (),
    Actuators[Events] < 50, "High Efficiency",
    Actuators[Events] >= 50
        && Actuators[Events] < 75, "Regular Efficiency",
    Actuators[Events] >= 75
        && Actuators[Events] < 99, "Medium Efficiency",
    Actuators[Events] >= 99
        && Actuators[Events] < 140, "Low Efficiency",
    Actuators[Events] >= 140, "Very Low Efficiency"
)

Best regards

Jay