Analytics

Analytics

The analytics feature has been added, allowing dashboards to be designed according to personal wishes. You can create insight into (almost) any desired data cross-section through widgets. For example, a bar graph with the number of pipes per status (ok, serious, critical) or an overview groups with the most issues. It is a strong tool that gives users the power to improve monitoring of assets not only on the component level but more importantly on the system (population) level. The video below is an example.
A user can create multiple dashboards.

Functionalities

Default dashboard

The user can select the default dashboard which will be displayed first when selecting Analytics from the left-hand side panel. This can be set by selecting the three dots in the top right-hand corner and selecting Use as default.
The analytics functionality also offers a direct link between the individual measurements, devices, locations and groups viewed in tables. This way, it is easy to navigate to location of interest.

Duplicate widgets

Duplicating widgets is possible with a single click of a button. This comes in handy when you want to use an existing widget as a starting point for a new one. Widgets can be also copied across different dashboards.

Download and exporting widgets

Bar charts, line charts and scatter plots can be easily downloaded as PNG. For all widget types, it is possible to export the search query into a csv file.

Limit number of rows in table

The number of rows in the table defines how many points will be used in the visualization. The default setting of 30 rows can be easily adjusted up to a maximum of 100 rows.

Visualization

The visualization options are available as tables, bar charts, stacked bar charts, line charts, scatter plots, and map widgets.
The layout of the analytics dashboard panels can be easily customized by resizing or dragging individual widgets according to your own preference.
All widgets which are build as bar charts, line charts and scatter plots can be directly downloaded as PNG.

Tables

Tables are constructed from the source tables and are the starting point to creating any type of visualization. Therefore, the first step when creating a widget is to select a source table. A source table determines which columns you have available for your analysis. The following source options are currently available:
Source table
Explanation
Locations
Includes devices and device type
Ports
Includes location, device and device type
Lines
With current condition
Port condition
Monthly statistics on issue triggers per port
Location condition
Monthly statistics on issue triggers per location
Line condition
Monthly statistics on issue triggers per line
Measurements
All historical measurements including linked static data
Reports
Includes locations, report types, devices, device types and users
Issues
Includes users, locations, devices, device types
Commands
Includes command types, devices, device types and users
Each table can be constructed from a number of columns. The analytics feature allows the user to perform various operations on columns, such as aggregating, grouping, ordering, and adding custom restrictions for filtering.
Every column can be renamed!
  • Adding multiple constraints to a single restriction is eventually the same as logical OR. This means, that at least one constraint should be true for a row to be included.
  • Logical AND on a set constraint can be achieved by adding a new restriction for each constraint.

Result limitation

You can set a limitation on the number of rows per unique value of one or more columns. With this feature, you can, for example, show only the last two measurements per location.
In the following tutorial, we explain step-by-step how to use the result limitation feature to limit the number of measurements per location.

Bar charts

The platform offers two forms of bar charts: clustered and stacked bar charts.

Line charts

The following example demonstrates how to create a line chart widget. In this example, day-ahead electricity prices from ENTSO-E are used as a measurement source for the widget.

Scatter plots

Scatter plots can be used to visualize a collection of points placed using Cartesian coordinates.

Map widgets

Map widget gives users the power of analytics to create custom maps. This can help you improve the overview of assets of interest. In the following GIF, we demonstrate how you can filter for a single type of asset and create a map widget with a custom tooltip. You can also learn how to create a map widget by watching a video we made on map widgets.

How-to video

The following example will demonstrate how to create a simple widget to view a list of most loaded transformers in last 90 days.
Copy link
On this page
Analytics
Functionalities
Default dashboard
Direct link
Duplicate widgets
Download and exporting widgets
Limit number of rows in table
Visualization
Tables
Bar charts
Line charts
Scatter plots
Map widgets
How-to video