For each widget element, such as axis, dimensions or measures, you can edit the settings, for example, axis title, display 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 chart is displayed in the dashboard 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 the 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, for example, 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. |
Sorting |
Sorts the labels of the X-axis data points in ascending or descending order or it sorts the labels of the X-axis data points according to the order of a data column that is assigned to the chart. The option is not available in a line chart if a date column is assigned to the X-axis. The "Sort by" option is not available if a partition is assigned. |
Sort by |
Sorts the labels of the X-axis data points by any column assigned to the chart. The option is not available if a column is assigned to the Partition. |
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 |
Enables you to specify the Axis title and Axis format. |
Data range tab |
Enables 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 |
Enables you to specify KPI thresholds and ratings. You can set the background or the graphic color depending on the KPI values. |
Thresholds tab |
Enables you to specify the thresholds values range and to set the background and graphic color accordingly. You must assign at least one KPI to the Y-axis. |
Rating tab |
Enables you to specify the KPI rating and to set the data point color accordingly. You must assign a single KPI to the Y-axis. |