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