Menu
This is documentation for the next version of Grafana documentation. For the latest stable release, go to the latest version.
Documentation
Grafana documentation
Visualize data
Panels and visualizations
Query and transform data
Calculation types
Grafana documentation
Visualize data
Panels and visualizations
Query and transform data
Calculation typesGrafana Cloud
Enterprise
Open source
Calculation types
The following table contains a list of calculations you can perform in Grafana. You can find these calculations in the Transform tab and in the bar gauge, gauge, stat, and table visualizations.
| Calculation | Description |
|---|---|
| 1st % - 99th % | 1st - 99th percentile value. |
| All nulls | True when all values are null |
| All unique values | Array with all unique values |
| All values | Array with all values |
| All zeros | True when all values are 0 |
| Change count | Number of times the field’s value changes |
| Count | Number of values in a field |
| Delta | Cumulative change in value, only counts increments |
| Difference | Difference between first and last value of a field |
| Difference percent | Percentage change between first and last value of a field |
| Distinct count | Number of unique values in a field |
| First | First value in a field |
| First* (not null) | First, not null value in a field (also excludes NaNs) |
| Last | Last value in a field |
| Last* (not null) | Last, not null value in a field (also excludes NaNs) |
| Max | Maximum value of a field |
| Median | Median value of all values in a field |
| Mean | Mean value of all values in a field |
| Min | Minimum value of a field |
| Min (above zero) | Minimum, positive value of a field |
| Range | Difference between maximum and minimum values of a field |
| StdDev | Standard deviation of all values in a field |
| Step | Minimal interval between values of a field |
| Total | Sum of all values in a field |
| Variance | Variance of all values in a field |
