A speedometer chart displays an aggregated numeric measure in a data range arranged in a half-ring chart. A red pointer indicates the actual value of the KPI.
Setup options
Data assignment
You can assign a numeric measure to the speedometer chart.
The following setup options are available:
Setup options |
Description |
---|---|
Data source |
Displays the columns of the assigned data source. Click |
Measure |
Displays the measure assigned to the widget. Click + Add measure and select a measure. AVG (average) is preset as default aggregation method. Click
the |
Configure thresholds |
Allows you to configure thresholds and corresponding colors for the measure values. |
Configure data range |
Allows you to configure a data range for the measure values. Opens the panel to configure the axis and measure appearance. See below for more details. Enables you to specify a range for the measure values to be displayed for constants or numeric data columns. By default, the data range is dynamically adapted. To define a data range, disable the Dynamically adapt option and specify the rage limits From/To. You can enter If you specify a data range, the cells outside the range are displayed with a fully saturated color. |
Auto-refresh data |
Enables automatic data retrieval for the widget. |
Edit the measure
You can edit the column assigned to the widget. Move the mouse pointer over the measure
and click Edit.
The following setup options are available.
Setup options |
Description |
---|---|
Display name |
Name of the criteria displayed in the widget. Click Revert to '...', to restores the initial display name. |
Aggregation |
Aggregation type for the column values: Average, Sum, Minimum, Maximum, and Count. Default is Average (AVG). Select an aggregation type. |
Treat as timespan |
The column is used as timespan. The option is disabled by default. Enable the option and specify the time span settings. Base unit Select the base unit for the timespan, for example, seconds or minutes. Use decimal fractions Allows to specify the number of decimals. The option is enabled by default. Select the decimal fraction in the Precision drop-down menu. The default is Auto. |
Precision |
Allows to select the decimal fraction in the drop-down menu. The default is Auto. |
Enable Prefix/Suffix |
Allows to specify a prefix and suffix.
|
Thousands separator |
Displays a thousands separator in the column values. |
Abbreviation |
Values are displayed abbreviated. |
Appearance
Widget appearance
You can configure the appearance of the widget.
The following appearance options are available.
Appearance options |
Description |
---|---|
Chart type |
Displays the chart type of the widget. You can switch the chart type to other gauge chart types in the drop-down menu. |
Title |
Optional widget title. You can specify a title in the input field. |
Add subtitle |
Adds an optional subtitle. |
Measure color |
Specifies the color of the measure bar. Click the color box and select a predefined color or specify an individual color on the Custom tab. |
Y axis |
Allows you to specify the appearance of the axes and the measure values. Click |
Scale |
Displays a scale in the chart. |
Scale value |
Displays the scale values in the chart. |
Measure value |
Displays the measure value in the widget. |
Axis and measure appearance
You can configure the appearance of the Y axis and the measure values. Click Edit in the line of the Y axis to specify its appearance.
The options provided depend on the selected criterion (axis or measure) and the data type of the assigned column.
The following appearance options are available.
Appearance options |
Description |
---|---|
Axis title |
Title displayed on the axis. By default, the column name is automatically used as title. Disable Auto axis title to change the title in the input field. |
Number formatting |
Enables you to specify the number format. Here you can enable the options Treat as Time span, Precision, Enable Prefix/Suffix, Thousands separator, and Abbreviation as in the setup options. |
Treat as timespan |
The column is used as timespan. The option is disabled by default. Enable the option and specify the time span settings. Base unit Select the base unit for the timespan, for example, seconds or minutes. Use decimal fractions Allows to specify the number of decimals. The option is enabled by default. Select the decimal fraction in the Precision drop-down menu. The default is Auto. |
Precision |
Allows to select the decimal fraction in the drop-down menu. The default is Auto. |
Enable Prefix/Suffix |
Allows to specify a prefix and suffix.
|
Thousands separator |
Displays a thousands separator in the column values. |
Abbreviation |
Values are displayed abbreviated. |
Data range |
Enables you to specify a range for the measure values to be displayed for constants or numeric data columns. By default, the data range is dynamically adapted. To define a data range, disable the Dynamically adapt option and specify the rage limits From/To. You can enter If you specify a data range, the cells outside the range are displayed with a fully saturated color. |
Logarithmic scale |
Displays the measure values of numeric data columns in a logarithmic scale. This is useful if you want to display a large range of values. |