AnsweredAssumed Answered

Batch count the number of times output value equals 0 from PI in excel

Question asked by ldryden on Nov 28, 2016
Latest reply on Dec 22, 2016 by Luke Yarnall

Hi All,

 

I am struggling to work out how to count the number of time a PI value reads 0 in a defined time period. For the graph below i would like the output cell in excel display the number of times the value reaches 0 in the last 4 hours of running. I used 'calculated data' with the inputs as shown below however does not appear to work.

Any help would be greatly appreciated.

 

Thanks

 

Luke

Outcomes