Gauge Chart
A gauge chart displays a numeric value in relation to a lower and upper bound as a semicircle with a positional indicator for the value in relation to the bounds, as may be most familiar from a speedometer.
Data Requirements
The gauge chart is available if the query results contain exactly one row of data with a numerical value, which is the "gauge value". Up to 10 additional values (columns) can be used to dynamically define the range boundaries of the gauge (see Configuration). For example, a result row such as
| value | bound1 | bound2 | bound3 | bound4 |
|---|---|---|---|---|
| 1 | 0 | 10 | 20 | 30 |
produces a gauge chart that looks as follows (with the default configuration):
Interactive Features
A gauge chart is not interactive.
Configuration
The following configuration options are available on a gauge chart:
- 240°: Whether the arc of the gauge spans 240 or 140 degrees.
- Value label: Whether the current gauge value should be displayed in the center of the gauge.
- S, M, L, XL: The preset size options for the range boundary labels on the gauge.
The ranges of a gauge chart can either be dynamic (defined by the query result row), or static (manually configured).
Dynamic Ranges
To use dynamic ranges, select From query in the gauge chart configuration. The
second value in the result row marks the lower bound of the first range, the
third value the lower bound of the second range, and so on. The ranges are
always continuous.
To change the color used for a range, click on the colored square next to it.
Manual Ranges
To use manually configured ranges, select Manual in the gauge chart
configuration. The SQL query should only produce a single value, which is the
current gauge value at time of query execution.
To change the color used for a range, click on the colored square next to it.
It is generally desirable, but not mandatory, for the ranges be continuous, i.e. the upper bound of one range should equal the lower bound of the next range.