Aggregating Value Columns Based on Type
Each of the value column configured to widget, can be aggregated individually based on the type you define. Following table illustrates the aggregation types and their use.
|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.|
|StdDev||Calculates the standard deviation of all members.|
|Var||Calculates the variance of all members.|
|DistinctCount||Returns the distinct count of all members.|
|Weighted Score||Calculates the weighted average of all members based on another column defined.|
|None||Allows you to view data without aggregation but grouped|
SSAS data source don’t have this option enabled for value columns as these columns were pre-aggregated in cube itself.
None option is only applicable to the Grid widget and the ODBC ANSI SQL connection in Live Mode does not support this option.
Refer the Configuring and formatting dashboard widgets sections for changing the aggregation types for the added fields in the widgets.