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,