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 traffic light displays the status of a KPI. A colored marker shows the threshold range in which a KPI value is located.
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 numeric or text Data column to the KPI element.
A data source column is assigned to the KPI element.
You can further configure the widget as follows:
For the displayed KPI value range you can define a minimum and a maximum value. Additionally you can compare the actual KPI value against several threshold values. The value ranges in the speedometer are indicated by various colors.
See the Options list below for details.
Procedure
Click the source column assigned to the KPI and specify the settings.
Click Thresholds to specify the KPI thresholds. See Configure thresholds for details.
Click OK to save your settings and to close the dialog.
The traffic light is displayed using the 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. |
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. |
You can define thresholds for numeric and text columns to display the status of a KPI. A colored marker shows the threshold range in which a KPI value is located.
By default, there are three traffic light stages plus the inactive stage.
Procedure
Click Thresholds.
The option is only available if a column has been assigned to the KPI.
Select Color and shape in the drop-down menu to display the traffic light stages with various colored shapes.
Click a color box to select a color and a shape for each threshold stage.
Select Image in the drop-down menu to use custom images instead of the colored shapes for each traffic light stage.
Select an operator for each threshold to define the KPI value range, for example, < (less than).
The available operators differ for numeric values (for example, < (less than) or = (equals to)) and text columns (for example, starts with or is equal to).
Enter a value for each threshold.
You can either enter specific threshold values or you can choose columns from your data source representing dynamic threshold values. Only numeric data columns are allowed for dynamic threshold values. Assign the required numeric data column from the data source to a threshold field using drag and drop.
Click the Plus button to add a threshold or the
Minus button to remove a threshold.
By default, the traffic light stage is also visible if it is inactive (A KPI value is not available.). Disable the Inactive state option if the traffic light stage should not be visible. You can also change the color of the inactive traffic light stage. If you use custom images, you cannot change the color. You can only deactivate the Show inactive state option.
The thresholds are configured for the selected widget.