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

Hello Luke,

There are a few ways to count the number of times a tag equals a particular value. One way is to use the Calculated Data function with a filter expression, as in my example below. Use the tagval function in the filter expression to specify the value it should equal, and make sure that calculation mode is set to count and calculation basis is set to event-weighted.

Let us know if this works for you!

Best,

Luke