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