Is it possible, in AF, to have a series of aggregate values for an attribute, such as 15 minute averages, and then present that data in a notification?
How much data would be in the Notifications? Only the average for the last 15 minutes? Or a series of averages with corresponding timestamps? Can we use PI Points?
I am looking at time spaced averages for a series of tags for an extended time period.
For example, it may be 5 tags with 15 minutes averages for the previous 24 hours.
However, there may be a desire to have more or less tags, different intervals or a longer period of time.
While all of this CAN be done with tags for each interval for the defined time range, that becomes cumbersome to both build and maintain, especially if the same 'template' is used for multiple sites.
This is more looking to stress the use of AF and Notifications and determine the maximum capabilities.
Thanks for the clarifications. Let's split this up into two questions as there are two different products involved.
1) How to calculate a scheduled aggregated time-spaced average in AF without the use of PI Points?
This isn't currently supported with an out of the box solution. In AF, it's possible to configure an Analysis and an attribute with an Analysis Data Reference (when Save Output History: No is selected in the UI)* to calculate an average based on an event triggered schedule. It's however not possible to configure an analysis data reference for a periodic (time spaced) calculation. We have this as an enhancement request on user voice: Sampled Data with Analysis Data Reference – Customer Feedback for OSIsoft & the PI System
If the input data to the average is a PI Point, you could maybe use the value retrieval method By Time Range: Average in the PI Point data reference configuration. This would be a client side real time calculation not a scheduled calculation.
This doesn't require an extra PI Point, simply an attribute configured with a different retrieval method for the same PI Point.
Finally, relaxing the restriction on not using PI Points (for the other readers, I know this isn't possible for your use case), you could configure an analysis to be ran periodically every 15 minutes using the PE TagAvg('Attribute','*-15m','*') and output to an attribute with a PI Point data reference (Save Output History: Yes)*.
*-Print screen for reference:
2) How to include the compressed data in a Notifications?
In the message format of a PI Notifications it's possible to specify a single value at start or send time. It's not currently possible to include a series of compressed values from the PI Data Archive. That being said, it's possible to include a PI Vision link and/or an attachment. The attached file could be, for example, an excel file with PI DataLink that retrieves the compressed data. There may be other ways of doing this, but these are the more frequent ones we suggest to customers. It's important to note that PI Notifications is designed to be a Notification system and not a reporting system. If you would like to have the product enhanced, please make a user voice request as I couldn't find an existing one.
Let me know if you have any follow up questions!
Retrieving data ...