Time Summarized Metrics

Prev Next

This page describes how to configure the Time Summarized Metrics widget. The general description of this widget can be found here: Time Summarized Metrics Widget Documentation.

This widget is intended for use in Dashboard applications and Report applications.

This widget supports the following datasources:

Configuration

General Tab

This tab is composed of four sections:

  • Time Ranges: Sets the duration of the period used on the widget.
    image.png

  • App Linked Data Sources: Displays all usable data in the widget.
    image.png

  • Output configuration: Defines the rows and columns that will be displayed.
    image.png

Time Ranges

Enter the period length and formatting options. A preview is displayed below the input area.

  • Range: Choose between:

    • Hourly

    • Daily

    • Weekly

    • Monthly

    • Quaterly

    • Yearly

  • Custom date format: If specified, allows to define the date format that will be used on the table headers. image.png

    • By selecting Custom, it is possible to enter a specific format. A preview is displayed: image.png

  • Use exact time period: If enabled, adds precision on the last time range, as shown on the preview: image.png

  • Hide future time intervals: If enabled, periods in the future will not be displayed.

App Linked Data Sources

For details on Linked app datasource see Widget Configurations.

Output Configuration

Prerequisites for a multi-asset use

In order to display information on multiple assets simultaneously, an aggregation method for each data used must be defined in the corresponding data source.

Rows
Click the button to add a new row, then enter its definition:
image.png

  • Name: Name of the row, that will appear on the table

  • Data: Select a data point from linked data sources

  • Type: Time Series

  • Interval: the interval defined in Time Ranges

A row can be moved up and down using , and deleted using the button.

Computed Columns
Click the button to add a new column, then enter its definition:
image.png

  • Name: Name of the column, that will appear on the table

  • Row Aggregation: Choose between None (no value selected), average, count, maximum, minimum

  • Computed Expression: In addition to the standard functions that can be used via Row Aggreagation, it is possible to define your own functions. Click on the elements shown in blue (corresponding to the elements already configured) to add them to the Expression field, then add the necessary mathematical operators.

image.png

Concrete example
For the following configuration:
image.png , the resulting table will be of the form:
image.png

Advanced Tab

Complementary content configuration
image.png

  • Table legend: Legend that will be added below the table.

  • Custom text in top left corner: Custom text to display in the top left corner of the table. Otherwise, the list of assets will be displayed (limited to 4).

  • Value Decimals: Number of digits to display after the decimal point.

  • Display year in column headers: If checked, the year is added in parentheses in the header of each data column.

  • Include Site name: If checked, the site name is added.

  • Swap rows and columns: If checked, reverse rows and columns.

Result of the above configuration, for the same example:
image.png

Table Styles
Allows to refine the table formatting, adjusting colors and font sizes, and disabling the side edges.
A preview is available in real time.

Example:
image.png

Result of the above configuration, for the same example:
image.png