Menu
Documentationbreadcrumb arrow Grafana Cloudbreadcrumb 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