TABLE DES MATIÈRES
- Introduction and Overview : grouping sensor data by label "Sensor by Label"
- Configuration of Sensors
- Available Indicators
- Data Aggregation Methodology: Aggregation
- Aggregation Delay
Introduction and Overview : grouping sensor data by label "Sensor by Label"
It is possible to group data from different sensors on single or multiple sites based on their label, a process known as "Sensor by Label."
For a single site, only sensors on the site with the relevant label will be considered.
Note : Only one label can be used per operation. SENSOR_LABEL does not take into account the time interval, fluid, or unit of the sensors. If time intervals differ, some aggregations in the widgets may not return data.
Additionally, only real sensors will be considered in the calculations of this algorithm. Virtual sensors will not be included.
Configuration of Sensors
A label can be added to a sensor through the asset file: Sensor Sheet, column AE
or via your site schematic:
Available Indicators
Five formulas can be used by users in their widgets:
- SUM_SENSOR_LABELS(label) : Sums the values of all labeled sensors over the aggregation period.
- MIN_SENSOR_LABELS(label) : Returns the lowest value among all sensors for the given period.
- MAX_SENSOR_LABELS(label) : Returns the highest value among all sensors for the given period.
- AVERAGE_SENSOR_LABELS(label) : Returns the average value among all sensors for the given period.
- COUNT_SENSOR_LABELS(label) : Counts the number of sensors with this label returning data over the period.
The formula should turn orange. If not, it indicates an error is present.
Data Aggregation Methodology: Aggregation
Example for 3 sensors with the same label:
- Sensor 1: Daily time interval (1 data point/day), sum aggregation
- Sensor 2: Daily time interval (1 data point/day), average aggregation
- Sensor 3: Weekly time interval (1 data point/week), sum aggregation
| Sensor | Recorded Data Week 1 | Weekly Aggregation |
|---|---|---|
| Sensor 1 | 7, 8, 7, 9, 7, 7, 5 | 50 (sum of all values) |
| Sensor 2 | 6, 5, 8, 7, 7, 7, 9 | 7 (average of all values) |
| Sensor 3 | 5 | 5 (sum of all values) |
Data Retrieval via SENSOR_LABEL in a Widget, Period "Week 1"
| SUM_SENSOR_LABELS | AVERAGE_SENSOR_LABELS | MIN_SENSOR_LABELS | MAX_SENSOR_LABELS | COUNT_SENSOR_LABELS | |
|---|---|---|---|---|---|
| Aggregation | (50 + 7 + 5) = 62 | (50 + 7 + 5)/3 = 20.7 | 5 | 50 | 3 |
The sensor aggregation is first performed (sum or average of its values), followed by the aggregation defined by the formula.
Aggregation Delay
When a user assigns a label to their sensor, it is necessary to wait until the next day (J+1) before the formulas mentioned above return data.
Unlike direct sensor calls (usable only on a single site, "@" then "Remote Data"), these algorithms aggregate data only once per day, each night.
Example: If a user creates a sensor on 08/29, assigns it the label "monthly_consumption," and uses the formula "SUM_SENSOR_LABELS(monthly_consumption)" in their shared analyses, it will only start returning data from 08/30.