Set properties of widget elements

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.

  1. Click the X-axis or Y-axis to specify the axis settings.
    1. Click the Text tab to specify the Axis title and Axis format.
    2. Click the Data range tab to limit the KPI value range.
  2. Click the source column assigned to the X-axis and specify the axis and column settings.
  3. Click the source column assigned to the Y-axis and specify the settings.
  4. Click the source column assigned to the Size by element and specify the settings.
  5. Click the source column assigned to the Partition and specify the settings.
  6. Click a source column assigned to the More columns (invisible) box and specify the settings.
  7. Click Coloring to specify the KPI thresholds. See Configure KPI thresholds for details.
  8. 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

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, that is for instance used for data points or tool tip. Available for columns of date and numeric type.

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.