All Collections
Dashboards
Dashboard Tiles
Dashboard Summary Functions
Dashboard Summary Functions

A full list and explanation of the summary functions available in the Dashboard Builder.

Shem Bogusz avatar
Written by Shem Bogusz
Updated over a week ago

Summary functions are used in Dashboard tiles to determine how multiple values are aggregated and summarised into a single value, for displaying as a visualisation like a bar on a chart.

Following is a list of available summary functions and an explanation on how they'll aggregate the data.

Count

Counts the number of values.

Count Distinct

Counts the number of distinct values.

Sum

The sum of the values.

Min

The smallest value.

Max

The largest value.

Average

The average of the values.

StdDev

An estimate of the standard deviation of a population where the sample is a subset of the entire population.

StdDevP

The standard deviation of a population where the population is the entire data to be summarised.

Var

An estimate of the variance of a population where the sample is a subset of the entire population.

VarP

The variance of a population where the population is the entire data to be summarised.

Median

The median of the values. A median is the number separating the higher half of a value range from the lower half.

Mode

The mode of the values. A mode is the value that is repeated more often than any other.

Did this answer your question?