I have the value for this - tagmax('abcd','01-Jan-19','*'), but how do I get the date of the Max Value?
Hi Bradley,You could pass the value returned from the TagMax function to a FindEq function. Something like:FindEq('abcd','01-Jan-19','*',TagMax('abcd','01-Jan-19','*')) That will return the timestamp closest to the starttime, within the given range, for which the point was equal to the given value.
Also, have you seen the AF Analysis product?OSIsoft: How to Setup Expression Analyses with PI AF [PI AF 2014- v18.104.22.16843] - YouTube
Please let me know if you have any questions about this.Thanks,Javin
In PI Af analysis, use the Timestamp Function, this Function returns the Timestamp of the Maximum value.
Change your expression as below, it will work.
I tried that exact expression and it fails....
There was a problem with the performance equation. Error from server:
PI PE syntax error in Expression. [-12300] Performance Equation error
Yes, as I mentioned it will work only in PI AF Analysis. As Javin Spann suggested you need to use the FindEq function for Performance Equation.
Thats the ticket...I was looking at the FindEq, but wasnt sure if it was the right way or not. Thanks again
Retrieving data ...