AnsweredAssumed Answered

Daily summary report with report builder

Question asked by A.Tedjoe on Nov 19, 2018

Dear Experts,

 

I have created a daily summary report in report builder which gives me the average values of tag from PI with a data span of 24 hours.

However the report shows erroneous outcomes. There is a shift of the average value from the day before e.g the average value of 03/11/2018 shifts to 04/11/2018 in the table.

See Attachment: e.g 04/11/2014 gives the average value of 03/11/2018

 

I am using the following query:

SELECT tag, time, value FROM piarchive..piavg

WHERE tag = 'sinusoid' AND time BETWEEN '03-nov-2018 00:00:00' AND 't+24h' and timestep = '24h'

and calcbasis= 'eventweighted'

 

Could you please provide me some feedback on how I could correct this.

 

Regards,

ATedjoe

Outcomes