A KPI widget shows a single number.

Data shape


NQL structure

Aggregation - most commonly used

summarize <kpi> = <sum() | count() | avg() | max() | min()>

NQL examples

Refer to the Live Dashboards NQL examples documentation for more information.

KPI specific form fields

  • Label: enter the text for the KPI metric. The text can contain special characters. There is a 50-character limit on the label.

  • Widget description (Optional): Enter an optional text description to explain, for example, how the metric should be interpreted, how it is calculated, or any subtleties to the metric. The title is required before the description can be entered. After you enter the description and press done, an info icon appears next to the title in the dashboard. When you hover over the icon, the information you have entered appears as an info tip.

  • Display as percentage: you have the option to display the number as a percentage. The number is multiplied by 100, and the percent symbol is appended.

  • Rating: display the KPI in a way that quickly helps the viewer assess whether the data is indicating an issue. The system compares the value returned by the query against the thresholds you enter. Choose from:

    • 1 threshold: the KPI displays a rating either as the Good or the Bad state.

    • 2 thresholds: the KPI displays a rating in one of three states: Good, Average or Bad.

Click on the Invert button to invert the states to fit the needs of each case. You can enter only numeric values for the thresholds, such as decimals and integers, positive or negative. For typed values, refer to the following table as the unit of the threshold value.

Typed valuesThreshold values


Enter the threshold as a decimal, for example, 0.9 would represent a threshold of 90%.


The threshold value is interpreted as the number of seconds.


The threshold value is interpreted as the number of bytes.


Last updated