AnsweredAssumed Answered

24 hour Average Calculation in Pi Data Link For Excel?

Question asked by sbn2b81 on Jun 28, 2018
Latest reply on Jul 6, 2018 by Lal_Babu_Shaik

I am having an issue in pi data link for excel and was hoping a more experience user could provide some guidance. I created compliance report for air emissions and keep getting conflicting information when I manually calculate the data based on the excel report I created. I created a report that pulls the 24 hour average of a specific Pi tag for each day in the current month however I don't think I did it correctly. I used the "calculated data function" in excel (see example below). I get a number for each day of the month but when i compare this with the daily average from pi it isn't even close to the same. Your feedback would be greatly appreciated.

 

Capture20.JPG

Outcomes