2 Replies Latest reply on Jul 6, 2018 9:05 AM by Lal_Babu_Shaik

    24 hour Average Calculation in Pi Data Link For Excel?


      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.