3.8 Data Aggregation
This feature is used to configure data sources for aggregation statistics. This feature must be completed before setting up Operation Records or Aggregation Reports. Different data types are aggregated differently. Data in INT/FLOAT/DOUBLE type is pre-aggregated for the sum value, average value, maximum value, minimum value, and number of reports; Data in BOOL/ENUM type will be pre-aggregated for the number of reports. Data is aggregated only after the configuration takes effect. Historical data cannot be aggregated.
Click “Add Configuration” and select the TSL model features to be aggregated in the pop-up window.
The added TSL model features are displayed on the “Data Aggregation” page, you can choose between Current Value or Total Value statistics mode.
For example,
- The device reports 20 at 02:59.
- The device reports 40 at 03:30.
- The device reports 50 at 03:59.
- The device reports 60 at 04:30.
- The device reports 80 at 04:59.
In Current Value mode:
The total value (sum value) is taken from the values reported by the device: The electricity consumption for 3 o'clock is 40 + 50 = 90, and for 4 o'clock is 60 + 80 = 140;
The average value = the total value of this hour / the number of reports. The average electricity consumption for 3 o'clock is 90 / 2 = 45, and for 4 o'clock is 140 / 2 = 70;
The maximum and minimum values are compared based on the actual reported values by the device. The maximum value at 3 o'clock is 50 and the minimum value is 40; the maximum value at 4 o'clock is 80 and the minimum value is 60.
In Total Value mode:
The total value (sum value) is taken from the difference between the previous and current values: The electricity consumption for 3 o'clock is (40 - 20) + (50 - 40) = 30; The electricity consumption for 4 o'clock is (60 - 50) + (80 - 60) = 30;
The average value = the total value of this hour / the number of reports; The average electricity consumption for 3 o'clock is 30 / 2 = 15, and for 4 o'clock is 30 / 2 = 15;
The maximum and minimum values are compared based on the difference between the previous and current values reported by the device. The maximum value (40 - 20) and the minimum value (50 - 40) at 3 o'clock; The maximum value (80 - 60) and the minimum value (60 - 50) at 4 o'clock.
