AnsweredAssumed Answered

How to count the number of times a tag exceeds a set-point for a specific duration of time in excel with PI DataLink?

Question asked by Luke_Eck on Sep 14, 2020
Latest reply on Sep 17, 2020 by Dan Fishman


What I am trying to accomplish is to be able to count how often a tag has exceeded a specific value and I only want to know if it has exceeded this for a prolonged period of time.  I am currently using PIAdvCalcDat-->Count-->Event-Weighted with a filter expression of " 'tag'>"value" AND PrevVal('tag','*') <= "value" and using compressed data and this works well for giving me a count of occurneces. What I want to know is if there is a good way to do this while but only for events that last greater then, say, 600 seconds?

Any help is greatly appreciated, thanks.