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 aggregate energy data, as well as baseline and target on request. Can be used to display energy data in public dashboards via the Kaizen public API.
Inputs
Meter Data 1: Raw Trend Log
Logic
Input TL [7] goes through the Delta block [13] to highlight changes that could be happening between samples, then the Delta feeds into a Multiple Expressions block [19] that works like a filter, and filters out any values below zero.
Data is then summed daily in the Aggregate block [1] and offset by a year [26].
Finally, the Data is calculated to show the desired 10% Energy saved baseline with block [31].