Each value column configured for the widget can be aggregated individually based on the type you define. The following table illustrates the aggregation types and their respective uses.
Aggregation type | Result |
Sum | Calculates the sum of values of all members. |
Count | Returns the count of all members. |
Average | Calculates the average of values of all members. |
Max | Returns the highest value for all members. |
Min | Returns the lowest value for all members. |
Median | Returns the Middle value for all members. |
Var | Calculates the variance of all members. |
DistinctCount | Returns the distinct count of all members. |