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.

CageCode

Specify the CageCode for the widget. When events are dispatched externally via the DTV SDK, if a cageCode is provided, only the object with the specified cageCode will respond

Hide Title

Select this to hide the title.

Title Font

Style the title label.

Title Jump

Select it and configure the title jump in the pop-up window. Read more in Title Jump.

Description

Write a short description of the widget. Read more in Widget Description. If a Description is written, hovering over the title will reveal the description under it.

Title Jump


You can set the title of the widget as a hyperlink. When the title is configured with a link jump, an arrow title_link will appear to the right of the title.

  • When the mouse hovers over the title text or arrow, the name of the jump will appear.

  • Clicking on the title text or arrow will trigger a jump.


The title jump supports the following configurations:

  • Link Name: Mouse hover over the title or right arrow title_link to display it.

  • Open in: Support multiple new page opening methods.

    • New Tab: Open a new tab in your browser.

    • Current Tab: Replaces the current tab with the target page.

    • Popup Window: Displays the new page as a pop-up window on the current page.

    • Bottom Drawer/Side Drawer:Sliding out a new page from the bottom/right side on the current page will partially block the current page, select X to close the drawer.

  • Redirection Method

    • No Link: The title is a normal text label.

    • Link URL: Redirects the user to a specified URL. You can specify the URL in the Title URL box.

    • Application Portal: Redirects the user to the menu of an application by specifying the App Identifier, Menu Identifier, and App Status fields.

Note

If no URL is specified when the link type selected is Link URL or Application Portal, the user is redirected back to the dashboard.


Other Options


Field

Description

Refresh Frequency

Select how frequently the widget should refresh and retrieve data from data sources.

Merge Request

When multiple widgets within one page using the same data source are refreshed simultaneously, the data requests will be merged into a single request. Enabled by default. Only valid when merge requests are turned on in the page setup, for more information, see Customizing Page Properties.

Allow Maximize

Select this to enable a clearer view of widgets, you can configure widgets to display in a full-page maximized view.

Allow Data Export [1]

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

Chart Padding

Specify the respective spacing within the widget.

Background Color

Select a background color for the widget.

Title Decoration

Select how you want to decorate the title.

Top Decorative Line

Add a decorative line for the top boundary of the container.

Bottom Decorative Line

Add a decorative line for the bottom boundary of the container.


[1] Not available for Topology.

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, and Extension

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 fields in the chart.

Unit

Add units for data fields, with priority over the original units of the data.


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

Note

  • If you need to add data from multiple data sources, contact your system administrator.

  • 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.

Built-In Data Source Parameters


For the built-in data sources, application users can configure the corresponding parameters to pre-process data for functions such as aggregation or filtering.

TSDB


For TSDB data sources, application users can configure the following information on the Data tab of Chart Settings (the data sources without parameters are not listed here).

LatestData


Item

Required/Optional

Description

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

Electric Power


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Aggregation Method

Optional

The method to aggregate time series data when queried by a designated interval. For example, if you select “avg”, the aggregated data will be the average value of data in the specified Aggregation Interval.

Aggregation Interval

Optional

The interval to aggregate time series data. For example, if you select “5 min”, the data within 5 minutes will be aggregated once.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

Raw Data


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

DI Data


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

AI Raw


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

AI Aggregation


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Aggregation Method

Optional

The method to aggregate time series data when queried by a designated interval. For example, if you select “avg”, the aggregated data will be the average value of data in the specified Aggregation Interval.

Aggregation Interval

Optional

The interval to aggregate time series data. For example, if you select “5 min”, the data within 5 minutes will be aggregated once.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

Generic


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

Common Data Service


For Common Data Service data sources, application users can configure the following information on the Data tab of Chart Settings.

Timeseries


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Aggregation Method

Optional

The method to aggregate time series data when queried by a designated interval. For example, if you select “avg”, the aggregated data will be the average value of data in the specified Aggregation Interval.

Aggregation Interval

Optional

The interval to aggregate time series data. For example, if you select “5 min”, the data within 5 minutes will be aggregated once.

Auto Retrieve Assets

Optional

Whether to automatically query all assets in the specified category.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

dimension

Optional

The dimension type for aggregating queried data or filtering specified metrics.

Placeholder

Optional

Whether to display the points without data as empty values.

Interpolate

Optional

Whether to return the latest data in the past if no data is found.

Display All Asset Data

Optional

If some data fields do not exist for an asset, whether to display other available data of the asset.

Query Type

Optional

The relationship between Category and Asset ID, affecting the scope to query assets.
  • General: the Category is the model of the assets in Asset ID. DTV querys all specified assets in Asset ID.

  • Hierarchy: the Category is the model of the sub-assets of the assets in Asset ID. DTV querys all sub-assets of the specified assets in Asset ID.

  • Grouping: the Category is the model of the asset groups in Asset ID. DTV querys the assets in the groups and aggregate asset data by group.

Realtime


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Accumulation Interval

Optional

The time interval to query realtime data. For example, if you select “Day”, DTV queries and aggregate realtime data by day.

Auto Retrieve Assets

Optional

Whether to automatically query all assets in the specified category.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

Display All Asset Data

Optional

If some data fields do not exist for an asset, whether to display other available data of the asset.

Query Type

Optional

The relationship between Category and Asset ID, affecting the scope to query assets.
  • General: the Category is the model of the assets in Asset ID. DTV querys all specified assets in Asset ID.

  • Hierarchy: the Category is the model of the sub-assets of the assets in Asset ID. DTV querys all sub-assets of the specified assets in Asset ID.

  • Grouping: the Category is the model of the asset groups in Asset ID. DTV querys the assets in the groups and aggregate asset data by group.

Alarm


Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

Data Size

Optional

The size of data to be displayed on the page.

Data Index

Optional

The index of the first alarm to query.

Asset Type

Optional

The types of assets to be displayed on the page.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

alertParentTypeIds

Optional

The IDs of parent alarm types to be displayed on the page.

alertTypeIds

Optional

The IDs of alarm types to be displayed on the page.

mdmTypeIds

Optional

The IDs of device types to be displayed on the page.

alertIds

Optional

The IDs of alarms to be displayed on the page.

Topology


Item

Required/Optional

Description

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

topologyID

Optional

The identifier of the topology.

ifCut

Optional

Whether to only display the parts of the topology associated to the assets in the specified Category.

Accumulation Interval

Optional

The time interval to query data. For example, if you select “Day”, DTV queries and aggregate data by day.

Display All Asset Data

Optional

If some data fields do not exist for an asset, whether to display other available data of the asset.

Record


Item

Required/Optional

Description

Data Index

Optional

The index of the first alarm to query.

Data Size

Optional

The size of data to be displayed on the page.

Metric Management


For Metric Management data sources, application users can configure the following information on the Data tab of Chart Settings (the data sources without parameters are not listed here).

Metric


Item

Required/Optional

Description

Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

mdmIdNotNull

Required

Whether to require a mdmId.

Asset ID

Optional

The identifiers to be displayed on the page. Leave it blank to display all assets in the specified category.

mdmId

Optional

The primary key of the dimension table, usually a business object identifier, which can be used to pass parameters to global filters.

GroupBy

Optional

The attributes in the GROUP BY clause, which can be used to classify the sampling data by group.

Fact Table


Item

Required/Optional

Description

Item

Required/Optional

Description

Start Time

Required

The start time of the sampling data.

End Time

Required

The end time of the sampling data.

pageNo

Optional

The number of page to be returned.

pageSize

Optional

The number of the returned records on a single page.

Time Field

Optional

The field in the fact table that represents time.

timeGroup

Optional

The time granularity for aggregating data.

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.


The available options are:

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

  • ASC: Display in ascending order.

  • DESC: Display in descending order.


Note

  • There can only be one sort. The order of priority is Dimension, Comparison and then Measurement. For example, if a sorting order is chosen for dimensions, the sorting order for comparisons and measurements is ignored. If there are multiple data fields in Dimension or Measurement, the first data field added takes the sorting priority.

  • For points on the x-axis where the first measurement added has a zero value, the sorting order for the next measurement with non-zero values is taken.

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 of 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.

Effect 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 the 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.