Assign data columns to pie charts

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).

Prerequisite

You have assigned a data source to the widget.

Procedure

  1. Click a widget on the dashboard. The relevant properties dialog is displayed.

  2. Click the Assign data Assign data icon to edit the data source assignment.

    The Assign data (2/2) dialog is displayed.

  3. Assign a numeric Data column to the KPI using drag and drop.

  4. Assign a text or date Data column as a dimension to the Partition using drag and drop.

  5. 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:

Set properties of widget elements

You can edit the settings, for example, display name or format, for each widget element, such as measure or dimension.

Various settings are available depending on the data type of the assigned data source column. See the Option list below for details.

  1. Click the source column assigned to the KPI and specify the settings.

  2. Click the source column assigned to the Partition and specify the settings.

  3. Click a source column assigned to the More columns (invisible) box and specify the settings.

  4. 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 (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.