Is there a way to aggregate average values every time interval (g.e. daily) instead of doing actual or interpolated value? I'd like the integrator to calculate daily averages for all values in the query.
You can click the existing column's header and then set the Column Data Content to Average instead of the default Value. Average means the values for each row in that column will be averaged over the time interval for each row. Please see the User Guide > How summary data is calculated and let me know if you have any questions.
Thanks for the information... I recently had the same question... I guess I am going to have to break down and read the manuals or watch the videos...
Since you are only able to change one column at a time, this can be a bit time consuming if you have a lot of attributes. One trick I've used in the past is to add corresponding attributes with the averages done by the PI Point Data Reference and then pull these attributes into my search shape rather than the raw PI Point value attributes. If you would like to see an enhancement to the current Integrator product to add bulk column edits, please vote here:
Provide Bulk Column Configuration – Customer Feedback for OSIsoft & the PI System
Retrieving data ...