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 Delta blocks, then a negative number filter to zeroes in order to prevent negative meter readings. Data is then aggregated and accumulated on an on-request interval.
