Aggregating Value Columns Based on Type
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. |