I would like to do hourly time weighted averages for
1) PI AF formula
2) PI AF analysis (without saving history)
but the column keep appearing blank. How should I address this issue?
I looked for limitations of the integrator to see if there were any limitations based on the type of DataReference used, but could not find any documentation on that quickly.
The first way i would check is to use PSE and go to the time-series data dialog on an attribute, and use that to request time-series data. If that returns average data on the summary tab, it could work.
My past experience is, it requires attributes with pi point datareferences aka history. Even Analytics data reference don't work.
Ryan, Hope this will help you PI Integrator for Business Analytics
That link point to the averaging functions, but what we are dealing with here is failing average values for interval values: https://livelibrary.osisoft.com/LiveLibrary/content/en/bi-v4/GUID-088276F9-897B-4591-8622-E6FA88FDF656
You could also do the calculation in the BI tool of choice if the other data is there. I often do event frame durations as a calculated column. I know Tableau and Power BI allow for columns to be created from other columns. Would that be an option?
Well, exactly time-weigted averages is what PI can do, but others not. And no way to do time-weigted average outside of PI if you need to pull data trhough the integrator, as the integrator does not allow to export raw data, only interpolated values on regular timestamps. So no way to get to the data in the first place to calculate a time-weigted average...
So far we can confirm PI Point-backed attributes work fine in Integrator, anything else without warranty...
True - I had to re-look at what Ryan was trying to do and your assessment is correct. I wasn't clear on exactly what he was trying to do until I stared at it long enough.
Thank you for posting about your issue using the PI Integrator to calculate averages on AF Formulas/Analyses. This is a Known Issue documented here:
147135 - Some types of data content return empty columns for formula data reference attributes
The workaround would be to convert the Formula to an Analysis and store the output history to a PI tag, then let the Integrator calculate the summary.
Let us know if you have any additional questions!
Thanks! That was the documentation that was missing. Although the 'documentation' is of course not the type we like...
Retrieving data ...