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 pie chart can display one numeric KPI iterated via a dimension (text or date dimension).
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 KPI using drag and drop.
Assign a text or date 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.