Set properties of widget elements

You can edit the settings for each widget element, for example, column name or format.

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

Procedure

  1. Click one of the assigned Grid columns to specify the settings.
    1. Click the Text tab and specify the settings.
    2. Click the Thresholds tab and specify the KPI thresholds. See Configure thresholds for details.
  2. Click a source column assigned to the More columns (invisible) box and specify the settings.
  3. Click OK to save your settings and to close the dialog.

The grid 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 tool tip. Optionally, you can add a prefix or postfix to the format, for example, $ 1,234 or 1,234 mm.

New column name

Replaces the data source column name, used for tooltips. 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 grid. Available for numeric columns. Enabled by default.

Show cell value

Displays the values of the column. Enabled by default.

Make clickable (for actions)

Makes the column clickable for triggering actions. See Specify actions for widgets for details.

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.

Set as key column for selection

Sets the selected column as key column.

When a selection is made and new data arrives, the selection is automatically recreated with the new data. The key column is used to ensure that the new data matches the selection. This means that if values in non-key columns have changed, the selected row remains selected even after new data arrives.

You can select one or more columns as key columns.

Text tab

Allows you to specify the New column name, Format and Aggregation.

Thresholds tab

Allows you to specify the thresholds values range.