Search results

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.