Documentation for automated readers
A curated documentation index is available at: https://grafana.com/llms.txt
A complete documentation index is available at: https://grafana.com/llms-full.txt
These indexes can help with page discovery before fetching individual documents.
This page is also available in Markdown, which may be easier for automated readers and AI tools to parse than HTML. The Markdown version is available at https://grafana.com/docs/grafana-cloud/visualizations/panels-visualizations/query-transform-data/calculation-types.md, or by sending Accept: text/markdown to https://grafana.com/docs/grafana-cloud/visualizations/panels-visualizations/query-transform-data/calculation-types/. For broader documentation discovery, the curated index is available at https://grafana.com/llms.txt and the complete index is available at https://grafana.com/llms-full.txt.
Grafana Cloud
Visualize data
Panels and visualizations
Query and transform data
Calculation typesCalculation 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 |
Was this page helpful?
Related resources from Grafana Labs
