AnsweredAssumed Answered

Monthly Averages Using PI Analytics

Question asked by kimmyberly26 on Feb 4, 2017
Latest reply on Feb 7, 2017 by Dan Fishman

I'm trying to calculate a monthly average using PI Analytics.  My current version I'm using is PI System Explorer 2016 R2.  The flow data is coming into the PI every 2 minutes.  The goal is to be able to pull up a trend that shows the timestamp for the first day of the month with the average monthly flow for that month.  I can get exactly what I want in PI Datalink but I'm having issues figuring out how to make it work in SE.


I have used both of the equations below.  While they are close, they aren't producing the same monthly averages that I'm getting in PI Datalink which is correct for what I need. I would also need the equation to calculate the current months monthly average.  For instance, today is Feb. 4th.  Even though the month is not complete, I would need the monthly average to date.

TagAvg('tag name','*-1mo','-2m') and TagMean('tag name',BOM('*'),'*')


Any help would be appreciated. Thanks!