Documentationbreadcrumb arrow Grafana documentationbreadcrumb arrow Visualize databreadcrumb arrow Panels and visualizationsbreadcrumb arrow Query and transform databreadcrumb arrow Calculation 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, stat, and table visualizations.

CalculationDescription
1st % - 99th %1st - 99th percentile value.
All nullsTrue when all values are null
All unique valuesArray with all unique values
All valuesArray with all 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
MedianMedian value of all values in a field
MeanMean value 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
StdDevStandard deviation of all values in a field
StepMinimal interval between values of a field
TotalSum of all values in a field
VarianceVariance of all values in a field