• State Not Answered
  • Replies 4 replies
  • Subscribers 3 subscribers
  • Views 185 views
  • Users 0 members are here
Options
Related

Handling Time Zone Differences in PI Analysis for Daily and Monthly Totals

NARESH KUMAR ADAVIPALLI

I am new to PI Analysis, and I am facing an issue with time zone differences. My data is stored in UTC, but the AF Analysis is performed in Central Time. Because of this, my daily and monthly totals are incorrect when using

'*'

 

for daily totals or

"BOM*"

for monthly totals.

Is there a way to handle this time zone mismatch by hard coding the dates or adjusting them iteratively in PI Analysis formulas? I would appreciate any guidance or suggestions on how to approach this.

Thanks in advance!

Parents
  • 0

    Hi Nash,

     

    Unfortunately, there is no simple way to get produce what we think should be simple results. The answer by Hupert does not take into account DST.

     

    There is a round about way to get it and I refer you to this blog:

    Exact Shift Starts Asset Analytics and Daylight Saving Time -DST

     

     Also, there is a subtle difference between relative times of '-1d' and '-24h'. For '-1d', what happens is the time zone on the host executing the analysis is used for whatever it thinks 1 day is. For US Central Time, this means 363 "civil" days will have 24 hours, 1 day will have 23 hours, and 1 day will have 25 hours.

     

    However, '-24h' always means 24 hours prior regardless of time zone.

     

Reply
  • 0

    Hi Nash,

     

    Unfortunately, there is no simple way to get produce what we think should be simple results. The answer by Hupert does not take into account DST.

     

    There is a round about way to get it and I refer you to this blog:

    Exact Shift Starts Asset Analytics and Daylight Saving Time -DST

     

     Also, there is a subtle difference between relative times of '-1d' and '-24h'. For '-1d', what happens is the time zone on the host executing the analysis is used for whatever it thinks 1 day is. For US Central Time, this means 363 "civil" days will have 24 hours, 1 day will have 23 hours, and 1 day will have 25 hours.

     

    However, '-24h' always means 24 hours prior regardless of time zone.

     

Children
No Data