To display data in the List widget, you must assign the relevant data source columns to the widget elements required.
You can assign one or two data source columns as list columns.
Prerequisite
You have assigned a data source to the widget.
Procedure
Click a list 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 data column to the List column box using drag and drop.
The list column is the main column by which the list can be sorted and filtered.
Optionally, assign a data column to the Additional column box using drag and drop.
The additional column shows additional values to the main column.
Optionally, assign one or more columns to the More columns (invisible) box using drag and drop. The columns are not displayed in the widget. They are used for filtering widgets only. See Define filters for widgets for details.
The data source columns are assigned to the widget elements.
You can further configure the widget as follows:
You can edit the settings, for example, column name or format, for each widget element.
Depending on the data type of the assigned data source column, different settings are available. See the Option list below for details.
Procedure
Click the assigned List column to specify the settings.
Click the assigned Additional column to specify the settings.
Click an assigned source column of the More columns (invisible) box and specify the settings.
Click OK to save your settings and exit the dialog.
The list is displayed in the dashboard with the data of the assigned data source.
Options list
Option |
Description |
---|---|
New column name |
Replaces the data source column name that is used by default. The column name is also used for the tool tip. |
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 grid. Available for numeric columns. Enabled by default. |
Aggregation |
Specifies how the KPI value is calculated. Available for numeric columns. Default is Average value. The number of aggregation types provided by context-based widgets may differ from that of non-context-based widgets. |