Objective: Filter and aggregate meter data from a raw cumulative Trend Log sample.
Method: Data transformation is performed in logic flow with aggregation interval on request. Negative cumulative values are replaced with zero values.
Outcome: Filtered and aggregate energy data on request. Can be used to display energy data in public dashboards via the Kaizen public API.
Logic
Input TL goes through Delta, 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.