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.
In the bubble chart you can display one dimension and two KPIs. The two KPIs are plotted on the x- and Y-axis. The dimension is represented by various colors of the individual bubble areas. Optionally, a third KPI can be incorporated; its values determine the size of the bubble areas.
Prerequisite
You have assigned a data source to the widget.
Procedure
Click a widget on the dashboard. The relevant properties dialog is displayed.
Click Assign data to edit the data source assignment.
The Assign data (2/2) dialog is displayed.
Assign a Data column as a KPI to the X-axis using drag and drop.
Assign a Data column as a KPI to the Y-axis using drag and drop.
Optionally, assign a Data column as a KPI to the Size by element using drag and drop.
Assign a Data column as a dimension to the Partition using drag and drop.
Optionally, assign one or more columns to the More columns (invisible) element 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, axis title, display name or format, for each widget element, such as axis, dimensions or measures.
Various settings are available depending on the data type of the assigned data source column. See the Options list below for details.
Click the X-axis or Y-axis to specify the axis settings.
Click the Text tab to specify the Axis title and Axis format.
Click the Data range tab to limit the KPI value range.
Click the source column assigned to the X-axis and specify the axis and column settings.
Click the source column assigned to the Y-axis and specify the settings.
Click the source column assigned to the Size by element and specify the settings.
Click the source column assigned to the Partition and specify the settings.
Click a source column assigned to the More columns (invisible) box and specify the settings.
Click Coloring to specify the KPI thresholds. See Configure KPI 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 |
---|---|
Scale type |
Specifies the scale type of the axis values. The scale type is available for axes with numeric values.
|
Axis title |
Title of the X- or Y-axis. Enable the title field and enter an Axis title. By default, the Automatic option is selected and the axis title consists of the concatenated names of the assigned columns. |
Axis format |
Output format of X- or Y-axis. The selected format overwrites the formats of the assigned columns. By default, Auto is selected and the individual formats are used for tooltips. Optionally, you can add a prefix or postfix to the format, for example, $ 1,234 or 1,234 mm. |
Display name (data point) |
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. |
Text tab |
Allows you to specify the Axis title and Axis format. |
Data range tab |
Allows you to specify the minimum value (From) and the maximum value (To) of the KPI value range. If the values are not set the values are calculated automatically. You can enter specific values manually or assign data source columns for a dynamic value assignment using drag and drop. |
Coloring > Thresholds |
Allows you to specify the thresholds values range and to set the background color accordingly. You must assign at least one KPI to the Y-axis. |
You can define thresholds for numeric and text KPIs to display their status. A colored background shows the threshold range in which a KPI value is located.
Procedure
Click Coloring.
Select the axis for which you want to define thresholds.
Click a Color box to select a background 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.
Select a threshold view style in the Style drop-down menu.
This option is only available for the background.
The thresholds are configured for the widget selected.