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 circular gauge chart displays a set of aggregated KPI values. The value ranges are arranged in a semicircle with a red pointer that indicates the actual value of the KPI.
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 Data column to the aggregated KPI using drag and drop.
A data source column is assigned to the KPI element.
You can further configure the widget as follows:
You can define a minimum and a maximum value for the displayed KPI value range. Additionally, you can compare the actual KPI value to several threshold values. The value ranges in the speedometer are indicated by various colors.
See the Options list below for details.
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 chart 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. |
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. |
Min value |
Minimum value of the displayed KPI value range. If the value is not set the value is calculated automatically. |
Max value |
Maximum value of the displayed KPI value range. If the value is not set the value is calculated automatically. |
You can define thresholds for a numeric KPI to display their status. A colored marker shows the threshold range in which a KPI value is located.
Click Thresholds.
Click a Color box to select a color for each threshold.
Select an operator for each threshold to define the KPI value range, for example, < (less than).
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 click the
Minus button to remove a threshold.
The thresholds are configured for the selected widget.