Speedometer chart

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 Edit Edit to open the data source settings in the data feed editor. Click Delete Delete to remove the assigned data source.

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 More icon and select an aggregation method.

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 Input constant values (default) or select specific columns to specify the limits. Click Add > Grid Select column and select a column to specify the limit.

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

  • Prefix: Appends given characters at the beginning of the cell value.

  • Suffix: Appends given characters at the end of the cell value.

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 Edit Edit to specify the appearance.

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

  • Prefix: Appends given characters at the beginning of the cell value.

  • Suffix: Appends given characters at the end of the cell value.

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 Input constant values (default) or select specific columns to specify the limits. Click Add > Grid Select column and select a column to specify the limit.

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.