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
Click a widget on the dashboard. The relevant properties dialog is displayed.
Click the Assign data icon to edit the data source assignment.
The Assign data (2/2) dialog is displayed.
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:
You can edit the settings, for example, display name or format for each widget element.
See the Options list below for details.
Procedure
Click the source column assigned to the Visible column element and specify the settings.
Click a source column assigned to the More columns (invisible) box and specify the settings.
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. |