Time based summary calculations
Ability to perform hourly, daily, weekly monthly, quarterly aggregation summary calculations on data.
Often useful for utility consumption KPIs / metrics.
James Brandt commented
A very common requirement, unfortunately currently made difficult in PI. The current workaround requires cascading a busy analogue into hourly buckets and then to daily buckets etc. This is done to take the load off the AF where the only other alternative is for PI to rerun calcs on busy analogues constantly and frequently.
This approach is difficult as triggers require the pre-requisite values (e.g. hourly) to be calculated before rolling up into the next calculation (e.g. daily). It is possible to hard code the timestamps in the analysis expression to get the required results, although for functions like tagtot, for periodic scheduling it resets values to 0 at midnight even if you require to Output Timestamp to relative trigger time. This cuts-off the calcs for the previous day. The requirement must ensure the values align at similar time intervals, not as a cascading rolled-up sequence that becomes out of sync with real-time).