Value calculations

When a visualization receives a numeric field, the data often contains a series of values rather than a single number. Use the Calculation setting to select a reducer function that aggregates the series into one representative value for display.

Supported chart types

The value calculation setting is available in the following chart types. These are the only chart types that display a single aggregated value per series.

• Bar gauge
• Gauge
• Metric

Missing values

A data series may contain NaN or null entries. Calculation methods marked with an asterisk (*) skip these invalid entries and operate only on valid numeric values. Methods without an asterisk use raw positional values regardless of whether they are valid numbers.

Available calculations

The following table lists all available calculation methods.

Calculation	Description	Requires valid values
First	The first value in the field.	No
First *	The first valid (non-null, non-NaN) value in the field.	Yes
Last	The last value in the field.	No
Last *	The last valid (non-null, non-NaN) value in the field.	Yes
Min	The minimum value among all valid values.	Yes
Max	The maximum value among all valid values.	Yes
Mean	The arithmetic average of all valid values.	Yes
Median	The middle value when all valid values are sorted.	Yes
Total	The sum of all valid values.	Yes
Count	The total number of values in the field (including null/NaN).	No
Distinct count	The number of unique values in the field (including null/NaN).	No
Variance	The statistical variance of all valid values.	Yes