Menu
DocumentationGrafana documentationPanels and visualizationsQuery and transform dataCalculation types
Grafana 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, and stat visualizations.
Calculation | Description |
---|---|
All nulls | True when all values are null |
All values | Array with all values |
All unique values | Array with all unique 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 |
Mean | Mean value of all values in a field |
Variance | Variance of all values in a field |
StdDev | Standard deviation 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 |
Step | Minimal interval between values of a field |
Total | Sum of all values in a field |
Was this page helpful?
Related documentation
Related resources from Grafana Labs
Additional helpful documentation, links, and articles:
Video
Getting started with the Grafana LGTM Stack
In this webinar, we’ll demo how to get started using the LGTM Stack: Loki for logs, Grafana for visualization, Tempo for traces, and Mimir for metrics.
Video
Getting started with Grafana dashboard design
In this webinar, you'll learn how to design stylish and easily accessible Grafana dashboards that tell a story.
Video
Building advanced Grafana dashboards
In this webinar, we’ll demo how to build and format Grafana dashboards.