A solid gauge displays an aggregated numeric measure in a data range arranged in a half-ring chart.
In addition, a half-ring divided into sub-ranges by threshold values can be displayed.
Example
Example for a solid gauge chart with thresholds.
Setup options
Data assignment
You can assign a numeric measure to the gauge chart.
Example
The Setup options of the solid gauge 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. |
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. Depending on the assigned data source, you can switch the chart type 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 |
Style |
Sets the size of the measure bar. Select the size from the drop-down menu. |
Show thresholds |
Displays thresholds in the chart. You can configure thresholds for the widget. |
Show min/max |
Displays the minimum and maximum values of the measure. |
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.
|
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. The option is disabled by default. |