Objective: Filter and aggregate meter data from a raw cumulative Trend Log sample and use historical consumption as a baseline with the adjustable target.
Method: Data transformation is performed in logic flow with aggregation interval on request. Negative cumulative values are replaced with zero values. The offset series retrieves historical consumption as a baseline, which is factored to calculate the target.
Outcome: Filtered and aggregated individual and total energy data as well as individual baseline and target on request. Can be used to display energy data in public dashboards via the Kaizen public API.
Logic
Input TLs go through the Delta blocks to highlight changes that could be happening between samples, then the Delta feeds into Multiple Expressions blocks that work as a filter, and filters out any values below zero.
Data is then summed daily in the Aggregate blocks and offset by years.
Finally. all the Data is calculated and summed to show the desired 10% Energy saved baseline.
