AnsweredAssumed Answered

Look for last date via signal-status

Question asked by MWichert82 on May 10, 2017
Latest reply on May 10, 2017 by rdavin

Hi there,

is it possible to use some of the excel-embeded functions of PI or any other trick (e.g vba macro) to search for the last date that a signal had a specific value ?

So for example, I would like to give a time range (e.g. 1/1/16-10/5/17) , the singal-tag and expression and then the function should find the last date, that the signal J3205.ST had the status "RUN", so that I can see how long this pump has been out of service ? If I use the compressed data, it goes to the right direction, I see all the status changes, although the timestamps inform about when the signal changed into this status and not from this status, so I see, when the pump started to run, not when it stopped.

 

I do not mind if the "procedure" get's a bit "heavy" because I do not plan to use it over a wide range of data, but I would like to be able to use it once in a while, that would save me a lot of klicking.

 

With kind regards,

Marcus

Outcomes