Common Widget Settings


All widgets have the same fields for Basic Information and Data Fields sections.



Basic Information

Basic Options

Field

Description

Title

Specify the default title for the widget. Supports Internationalization.

Hide Title

Select this to hide the title

Title Font [1]

Style the title label

Link Type

Select where to redirect the user when the title is clicked. Read more in Title Link.

Description

Write a short description about the widget

Other Options

Field

Description

Refresh Frequency

Select how frequent the widget should refresh and retrieve data from data sources

Allow Data Export

Select this to enable users to download the displayed data in CSV format

Chart Padding

Specify the respective spacing within the widget

Background Color [2]

Select a background color for the widget

Title Decoration [2]

Select how you want to decorate the title

Top Decorative Line [2]

Add a decorative line for the top boundary of the container

Bottom Decorative Line [2]

Add a decorative line for the bottom boundary of the container



Data Fields


Field

Description

Data Source

Select the data source.

Category

Select the data category that you want to display.

Aggregation

Select if you want to use the raw data, or the aggregated data. See Aggregation.

Dimension, Comparison, Measurement

Select the data fields according to the chosen widget. Required quantities of data fields for each widget can differ. For more information, see the reference page of the respective widgets

Alias

Add an alternative display text for dimension, comparison and measurement fields in the chart.


Depending on how the data source was configured in the backend, there may be additional optional parameters that you can configure.

Note

  • If you change the data source or the category, the current data fields will become irrelevant. You can replace them to retain the chart style, or remove them completely to reconfigure the chart style from scratch.

  • If you change an existing chart to a new chart type that is incompatible with the existing data fields, then all the data fields will be reset. You will need to configure them again. For example, if dimension fields were selected and you changed the chart type to the Donut Gauge type (which does not use dimension fields), all the data fields will be reset.


Data Source Specific Configuration

Common Data Service
For a data source under Common Data Service, you can select multiple categories and specify the asset ID. DTV will obtain data that matches both the selected categories and the asset ID.

  • If the asset ID is a parent asset, the selected categories represent the child assets.
    DTV will obtain data of the selected child assets under the specified asset ID.

  • If the asset ID is not a parent asset, it simply acts as a filter.
    DTV will obtain data that matches both the selected categories and the asset ID. For example, if you select categories Wind Farm A and Wind Farm B, and specify the ID of Wind Farm A in the asset ID, DTV will only obtain data of Wind Farm A.

Sorting Data Fields

For the dimension and comparison data fields that you have selected, you can choose the order they are displayed on the chart.


../../_images/sort.png


The available options are:

  • Default: Display in the same order as the original data

  • ASC: Display in ascending order

  • DESC: Display in descending order


In the example below, we have selected ID as the Dimension field. Selecting ASC for the ID field displays its data values in the ascending order.


../../_images/sort_before_after.png

Aggregation

You can aggregate measurement data values that have the same dimension and comparison data values. If no dimension and comparison data fields are selected, then measurement values of the same field are simply aggregated and returned as a single value.


For example, the Month June has two records, 5 and 10. After selecting Aggregation with the function Sum, the two values are added together and displayed as 15.


../../_images/aggregation_before_after.png


DTV supports the following functions for aggregation:

Function

Description

Sum

Returns the unweighted sum of measurement values

Average

Returns the average of measurement values

Effective Average

Returns the average of non-empty measurement values. For example, if there are 10 values, of which 6 are non-empty, the effective average returns the average value of the 6 non-empty values (whereas the average function would return average of all 10 values).

Max

Returns the largest measurement value

Min

Returns the smallest measurement value

First

Returns the first measurement value

Last

Returns the last measurement value

Count

Returns the number of measurement values

Distinct Count

Returns the number of unique measurement values