Single-metric gauge chart

Create a single-metric gauge chart to display a ratio of a single metric in relation to the total.

Data shape

<metric value>, <total>

NQL structure

Refer to the Live Dashboards NQL examples documentation for query examples of single-metric gauge widgets.

<devices|users>
| include <event table>
| compute temp_bad_number = <device|user>.count()
| summarize 
   <metric> = temp_bad_number.sum(), 
   <total> = count()

Configuring visualization fields specific to single-metric gauges

Refer to the Managing Live Dashboards documentation to learn how to fill in the remaining configuration fields that are not specific to this widget.

After selecting the Single metric gauge chart option from the Chart type dropdown in the Add widget/Edit a widget pop-up:

Use the Label (optional) field to create the visible name of the single-metric gauge.
- The text can contain special characters. There is a 50-character limit on the Label field.
Enter a Widget description (optional) to explain, for example, how the metric should be interpreted, calculated, or any subtleties to the metric.
- The widget description appears by hovering over the info icon next to the single-metric gauge widget in the dashboard.
Choose an output color for the gauge based on the data to define:
- Bad (red)
- Average (yellow)
- Good (green)
Alternatively, establish Rating thresholds to change the gauge color if the metric value exceeds the defined limits, allowing for quick identification of issues. Choose from:
- 1 threshold: the single-metric gauge chart is either green or red, depending on whether the metric exceeds the given threshold.
  - The system evaluates thresholds with the >= operator. The example above is evaluated as follows:
    Good: if the metric is < 35
    Bad: if the metric is >= 35
  - Select Invert to invert the good and bad conditions. When inverted, the example above is evaluated as follows:
    Bad: if the metric is < 35
    Good: if the metric is >= 35
- 2 thresholds: the single-metric gauge chart is either green, yellow or red, depending on whether the metric exceeds the given thresholds.
  - The system evaluates thresholds with the >= operator. The example above is evaluated as follows:
    Good: if the metric is < 35
    Average: if the metric is >= 35 AND the metric is < 65
    Bad: if the metric is >= 65
  - Select Invert to invert the good and bad conditions. When inverted, the example above is evaluated as follows:
    Bad: if the metric is < 35
    Average: if the metric is >= 35 AND the metric is < 65
    Good: if the metric is >= 65