Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
5 years ago

Filter a Measure Value

Hello All, 1. I have created a table for Measure Names to use a Filter,(CycleTime1,CycleTime2) 2.Created Two Columns  CycleTime1 = Datediff(Time2,Time1,Sec), CycleTime2 = Datediff(Time3,Time2,Sec) ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

harshagraj , Try like

UCL Filter = IF(([CycleTime])>[UCL],"Crossed UCL","Not Crossed")

 

or in Average , STDEV copy the calculation CycleTime , instead of using it

  • harshagraj's avatar
    harshagraj
    Post Partisan
    5 years ago

    Hi thanks for the reply. I tried the UCL Filter but getting same error. I didnt understand the 2nd Point.
    User Just need a UCL filter to see which are the spiked ones.