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!