Skip to content
Stand with Ukraine flag

Telemetry Aggregation

Every field added to a Trendz view has an aggregation type that controls how raw telemetry is reduced to a single value per time bucket or group. Choose the aggregation that matches the meaning of the measurement.

TypeDescription
AVGArithmetic mean of all values in the group.
SUMTotal sum of all values in the group.
MINSmallest value in the group.
MAXLargest value in the group.
LATESTMost recent value recorded in the group’s time range.
COUNTNumber of data points in the group.
UNIQNumber of distinct values in the group.

To change the aggregation type, click the field in the view configuration panel and select the required value.

Some devices report a monotonically increasing counter — a pulse output — rather than an instantaneous reading. A water meter, electricity meter, or gas meter are typical examples: the raw value always grows and the meaningful metric is consumption over a period, not the absolute counter.

Raw pulse counter (always increasing):
time ──────────────────────────────────────▶
value 100 150 210 290 310 400
Delta per interval (consumption):
time ──────────────────────────────────────▶
value 50 60 80 20 90

Select DELTA aggregation for such a field and Trendz will automatically compute the consumption for each time bucket at the chosen granularity.

When DELTA is applied to a field that spans multiple devices (for example, all water meters in a building), Trendz computes the delta for each device individually and then applies SUM to combine them. The result is the total consumption at any level of your topology — city, building, floor, or apartment.

Building (query result after DELTA + SUM):
┌─────────────────────────────────────────────┐
│ Building A — total consumption: 230 L │
└──────────────┬──────────────────────────────┘
┌─────────┴──────────┐
▼ ▼
┌─────────────┐ ┌─────────────┐
│ Meter 1 │ │ Meter 2 │
│ delta: 90 │ │ delta: 140 │
└─────────────┘ └─────────────┘
SUM → 230