Assign data columns to labels

To display data in a widget, you must assign the relevant data source columns to the required widget elements. For example, you can select a data column to display its values as dimension values on the X-axis.

A label displays a fixed text you have entered, or a text that is supplied dynamically by a data source.

Prerequisite

You have assigned a data source to the widget.

Procedure

  1. Click a widget on the dashboard. The relevant properties dialog is displayed.

  2. Click the Assign data Assign data icon to edit the data source assignment.

    The Assign data (2/2) dialog is displayed.

  3. Assign a source Data column to the Data column element using drag and drop.

A data source column is assigned to the widget element.

If you have assigned a text or date column to the widget the values are retrieved from the first data row.

You can further configure the widget as follows:

Set properties of widget elements

You can edit the settings, for example, display name or format for each widget element.

See the Options list below for details.

Procedure

  1. Click the source column assigned to the Visible column element and specify the settings.

  2. Click a source column assigned to the More columns (invisible) box and specify the settings.

  3. Click OK.

Your settings are applied. The drop-down menu in the dashboard is displayed with real data of the assigned data source.

Options list

Option

Description

Display name

New column name displayed in the widget, that is for instance used for KPI, data point or tool tip. By default, the data source column name is used.

Format

Output format of the column values, for example, used for data points or tool tips. Available for columns of date and numeric type.

For details on setting the date format, refer to the chapter Change data type - single value.

Note that the pattern for the day of the week used in the Assign Data 2/2 dialog is different from the pattern used in data feed processing. For the date format of the day of the week, you must use the pattern dddd instead of eeee as in the data feed processing. For example, the format dddd.MM.YYYY returns Monday.12.2019.

Round numerically

Displays rounded KPI values in the chart. Available for numeric columns. Enabled by default.

Initial selected value

Specifies the initial selected column value. By default, the first column value is selected.

Sort descending

Displays the column values in a descending order in the drop-down menu.