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