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 |