Skip to main content

Data Analytics

Transform your raw sensor data into actionable insights using visual calculations. Data Analytics enables operations such as averaging, summing, finding maximum and minimum values, and more, directly on your widget variables. This feature also lets you filter data, apply mathematical computations, visualize data as numbers, analyze trends, and perform other data transformations.

Data Analytics is currently available for the widgets listed below, with support for additional widgets to be added in the future:

Available Functions​

The following table lists the calculations you can perform:

FunctionDescription
Last ValueDefault for widgets with a single value; represents the last value of the variable.
All DataDefault for widgets with multiple values; shows all data of this variable or widget.
Last LocationFinds the last value with valid location data.
CountCounts the number of values for a variable over a selected period.
AverageCalculates the average value over a selected period.
SumComputes the sum of values over a selected period.
MaxIdentifies the maximum value over a selected period.
MinIdentifies the minimum value over a selected period.
ConditionalFinds values that meet a specific condition (e.g., greater than, less than, not equal) over a selected period.
AggregatePerforms a calculation (e.g., average, max, min, sum) based on an interval (e.g., daily, weekly, monthly).

Types of Functions​

Basic calculations​

These functions perform fundamental mathematical operations on data within a specified period, up to one month. All functions are considered basic calculations except for the Aggregate function. When applied, these calculations process all data within the chosen timeframe. Note that these calculations are limited to data in a period of 1 month.

Data aggregation operations​

This includes the Aggregate function, which aggregates data over an interval and applies mathematical operations. Unlike basic calculations, there is no period restriction; the calculation will be applied to all available data by default or to the period configured in the Dashboard Period Preset.

Available intervals:

  • Per minute
  • Per hour
  • Daily
  • Weekly
  • Monthly
  • Quarterly
  • Yearly

When applying an interval, the system uses the first data point as a starting reference. For example, if your data starts on January 1st and the selected interval is Weekly, then the data between January 1st and January 7th will be aggregated.

How to apply functions to your data​

  1. Open the widget in Edit Mode.
  2. Select a variable in Data From.
  3. Click the cog icon to access the Data Analytics tab.
  4. Choose a function from the list above.
  5. For basic calculations, define a period (up to one month).
    • The period can be set directly in the Data Analytics tab, on the X‑axis, or via global preset periods using the Dashboard Period Presets.
  6. For aggregation functions, set a default interval or create a preset interval by navigating to the Preset Interval option after entering the widget in Edit Mode.
  7. The system will prompt you to define Cache settings, which are mandatory for maintaining dashboard responsiveness and performance.