Assign data columns to line, column or bar charts

To display data in a widget, you must assign the relevant data source columns to the required widget elements (for example, to the X-axis).

In a line chart, column chart, or bar chart, you can display one dimension (X-axis) and several KPIs (Y-axis), or two dimensions (x-axis and partition) and one KPI (Y-axis).

Prerequisite

You have assigned a data source to the widget.

Procedure

  1. Click an inserted widget on the dashboard. The relevant properties dialog is displayed.
  2. Click Assign data Assign data to edit the data source assignment.

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

  3. Assign a Data column as a dimension to the X-axis using drag and drop.
  4. Assign one or more Data columns as KPIs to the Y-axis using drag and drop.

    If you have assigned a column to the X-axis and a column to the Partition, you cannot assign more than one column to the Y-axis.

  5. Optionally, assign a Data column as a second dimension to the Partition using drag and drop.

    If you have assigned more than a column to the Y-axis the Partition is no longer available.

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

Topics

Set properties of widget elements

Configure KPI thresholds

Configure KPI rating