Datasets are elements used to gather and present data using multiple data sources. The Datasets project folder contains the templates for Datasets that are templatized to be instantiated inside each component. The data from a dataset is not loaded until an instance from the same dataset exists and is referenced by another element.
Note:
Starting from N3uron version 1.21.7, the Node field is available. This new feature enables you to link the Historical Dataset to a remote node. By default, it is set to <This node>.
Starting from N3uron version 1.21.7, the addition of min and max properties to Datasets expressions has been implemented.
Historical Datasets
Historical Datasets present stored data organized into [date, value] pairs, where the date is a timestamp and value is the value associated with the given date. Data from Historical Datasets is retrieved from N3uron Historian modules. Historical Datasets include the following options:
Property | Description | ||
|---|---|---|---|
Tag | Path of the tag whose historical data will be loaded. | ||
Node | Remote node from which the tag data is requested. Leave this field empty to use <This node>. | ||
Date mode | Defines how the start and end dates are calculated. | ||
Relative | Calculates the start and end dates using offsets relative to the current date. | ||
Offset | Amount of time to subtract from the specified time. | ||
Time | Additional time offset. | ||
Absolute | Uses fixed start and end dates. | ||
Start | Absolute beginning of the period | ||
End | Absolute end of the period. | ||
Current | Loads data from a previous moment, defined by a negative offset, up to the current moment. | ||
Offset | Amount of time to subtract from the current time. | ||
Units | Seconds, minutes, or hours. | ||
Mode | Defines how historical data is represented. | ||
Aggregated | Groups data using the selected aggregation method and interval. | ||
Raw | Displays values exactly as they are stored in the historical database | ||
Delta | Displays values only when the difference from the previous value exceeds the configured dead band. Values after the change are included. | ||
Filter | Displays values only when the difference from the previous value exceeds the configured dead band. Values before and after the change are included. | ||
Autoreload | Configures automatic data reload. | ||
Enabled | Enables or disables automatic data reload. | ||
Interval | Reload interval, in seconds. | ||
Aggregation method | Tag configuration | Value configured within the tag. | |
Average | Returns the weighted time average during the aggregation period. | ||
Minimum | Returns the minimum value in the aggregation period. | ||
Maximum | Returns the maximum value in the aggregation period. | ||
First | Returns the first value in the aggregation period. | ||
Last | Returns the last value in the aggregation period. | ||
Delta | Returns the difference between the first and last sample during the aggregation period. | ||
Standard deviation | Returns the Standard deviation during the aggregation period. | ||
Derived Datasets
A Derived Dataset is a dataset in which the values are calculated from previously existing datasets or from manually defined datasets, allowing to transform, combine, or aggregate data without modifying the original datasets.
Internally, a dataset is an ordered collection of tuples. Each tuple represents a single sample and contains the timestamp together with its associated value. When mathematical operations are performed between datasets, calculations are applied tuple by tuple, preserving the dataset structure in the resulting output.
Properties
Property | Description |
|---|---|
Dataset | Expression that defines the resulting dataset. It can reference existing datasets, manually create datasets, combine multiple datasets, or perform mathematical operations. |
Datasets | List of available datasets that can be referenced from the Dataset expression. |
Dataset Operations
Mathematical operators can be applied between datasets, scalar values, or a combination of both. Unless otherwise specified, operations are evaluated tuple by tuple, producing a new dataset with the same structure as the input.
Operation | Behavior |
|---|---|
Dataset ± Number | The scalar value is added to or subtracted from every tuple value in the dataset. The timestamps remain unchanged. |
Dataset × Number | Every tuple value is multiplied by the scalar value. The timestamps remain unchanged. |
Dataset ÷ Number | Every tuple value is divided by the scalar value. The timestamps remain unchanged. |
Dataset ± Dataset | Values from matching tuples are added or subtracted, producing a new dataset containing the calculated values. |
Dataset × Dataset | Each tuple value is multiplied by the corresponding tuple value in the second dataset, producing a new calculated dataset. |
Dataset ÷ Dataset | Each tuple value is divided by the corresponding tuple value in the second dataset, producing a new calculated dataset. |
Note:
The result of any mathematical operation involving one or more datasets is always another dataset. The resulting dataset preserves the tuple structure while replacing each value with the calculated result.