I need to calculate the flow total for every 3 month. For example total from Jan to March and April to June and July to Sep, Oct to Dec.
Please help me...
Thanks for posting on PI Square and welcome to its community. I apologize for the late response time.
I believe this is the scheduling information that you'll need to get what you are after:
In case it is hard to make out, here is the syntax of the Performance Equation for writing results:
If '01-Jan'='*' or '01-Apr'='*' or '01-Jul'='*' or '01-Oct'='*' then 0 else 1
I'm running this calculation every 12 hours starting at midnight and it essentially checks if the timestamp matches the start date of the quarter.
I do want to point out that whenever possible you should look to PI Asset Analytics to perform these calculations. It is more efficient and helps keep you PI Data Archive from being Bogged Down by too many calculations.
Please give the above configuration a try and let us know if it works or if you have other questions.
Thanks for response and support. Let me try and come back to you. Thank You Jesse Ru
Retrieving data ...