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 a Heat matrix chart you can display three dimension (X-axis, Y-axis, and size) and descriptive data, such as label and tooltip.
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 to each of the widget elements X-axis, Y-axis, and Size by as a dimension using drag and drop.
Assign a data column to each of the widget elements Label and Tooltip as content using drag and drop.
The data source columns are assigned to the widget elements.
You can further configure the widget as follows:
For each widget element, such as axis, dimensions or measures, you can edit the settings, for example, axis title, display name or format.
Various settings are available depending on the data type of the assigned data source column.
Procedure
Click the X-axis column box and specify the axis settings.
Click the Display name (data point) to specify the column name of the dimension.
Click the Axis label to specify the label of the dimension in the chart.
Add or delete values and labels for the dimension values with Configured values and labels. The value must match the values received from the data column. The label describes the value and can be created individually.
Click the Y-axis column box and specify the axis settings.
Click the Display name (data point) to specify the column name of the dimension.
Click the Axis label to specify the label of the dimension in the chart.
Add or delete values and labels for the dimension values with Configured values and labels. The value must match the values received from the data column. The label describes the value and can be created individually.
Click the Size by box and specify the axis settings.
Click the Display name (data point) to specify the column name of the dimension.
Add or delete values and percentages for the dimension values with Configured bubble sizes. The value must match the values received from the data column. The percentage can be created individually and represents the data point bubble size to the other bubble size.
Click the Label box element and enter the Display name (data point) to specify the column name of the dimension.
Click the Tooltip box element and enter the Display name (data point) to specify the column name of the dimension.
Click OK to save your settings and to close the dialog.
The chart is displayed in the dashboard with real data of the assigned data source.