Menu
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.

CalculationDescription
All nullsTrue when all values are null
All valuesArray with all values
All unique valuesArray with all unique values
All zerosTrue when all values are 0
Change countNumber of times the field’s value changes
CountNumber of values in a field
DeltaCumulative change in value, only counts increments
DifferenceDifference between first and last value of a field
Difference percentPercentage change between first and last value of a field
Distinct countNumber of unique values in a field
FirstFirst value in a field
First* (not null)First, not null value in a field (also excludes NaNs)
LastLast value in a field
Last* (not null)Last, not null value in a field (also excludes NaNs)
MaxMaximum value of a field
MeanMean value of all values in a field
VarianceVariance of all values in a field
StdDevStandard deviation of all values in a field
MinMinimum value of a field
Min (above zero)Minimum, positive value of a field
RangeDifference between maximum and minimum values of a field
StepMinimal interval between values of a field
TotalSum of all values in a field