Is there a single functionality in PI Processbook data link for excel that would allow for finding the maximum of a data sets averages? Right now, I am first computed the averages using "Calculated Data" function and then using the excel maximum function to find the maximum of that data. However, I would like to do both at the same time using the PI data link in order to reduce processing time. Is there a way to do this?

Hi Ta,

I couldn't find a way to do this since the TagAvg performance equation requires a start and end time. The idea I was thinking of was to have an expression instead of data item, and have the expression be the tagavg of the tag. Then have the expression sampling be interpolated and set to the interval frequency, and have the calculation mode set to maximum. But, as I mentioned, that's not how the tagavg PE syntax works, so I don't think there's a way to do this as is.

When you mention processing time, though, depending on your use case, it could make sense to have the hourly averages (or whatever time interval you're using) stored as a PI tag. This could be accomplished easily enough with an AF Analysis (or PE if you're not using AF), then you can take the maximum of that attribute across a time period. The values would be pre-computed, therefore virtually no processing time at all.

Kelsey