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

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 NARESH KUMAR ADAVIPALLI 11 months ago

Thanks for the help! I have a few more questions.
I tried using
"EOM"
to get the end of the month, but it doesn’t seem to work as expected. Is there another way to accurately determine the end of the month in PI Analysis?
Appreciate your continued assistance!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 NARESH KUMAR ADAVIPALLI 11 months ago

Thanks for the help! I have a few more questions.
I tried using
"EOM"
to get the end of the month, but it doesn’t seem to work as expected. Is there another way to accurately determine the end of the month in PI Analysis?
Appreciate your continued assistance!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data