Summary Functions for Tables

Version

Application Scenarios

You can set the summary method for fields in Indicators of the table, allowing you to get calculation results quickly with frequently used functions.

Functions

There are seven modes in Summary Mode: Sum, Average, Median, maximum, minimum, standard deviation, and Variance.

Summary mode can only be used in group tables and cross tables.

Note: For calculation fields in Indicators, they will be first summarized according to the summary mode and then be calculated according to the function you have set.

The default summary mode for fields in Indicators is Sum, which summarizes the values for each group specified by fields in Dimensions.

For example, the Contract Amount column displays the total contract amount for different contract types.

Average is to calculate the average value of the fields in Indicator grouped by the fields in Dimensions. To failicate the understanding, drag and drop the Contract Amount and Contract Quantity fields to  Indicators. Then drag and drop the Contract Amount field to Indicators again to calculate the average value of it.

Contract Amount (average) = Contract Amount (sum) / Contract Quantity. The result is the average contract amount for different contract types.

Median refers to the middle number in a sorted list of all values of an indicator, grouped by fields in Dimensions. Sort the Permanent in the Contract Type in descending order according to the contract amount. The median is 2,769,000.

The median enables you to observe the characteristics of the middle data point, making the distribution of data clearer.

Group the fields in Indicator by the fields in Dimension and then calculate the maximum/minimum value within each group.

For example, the maximum amount of the contract in permanent type is 4,657,900 and the minimum is 550,000.

Take the square root of the variance of the fields in Indicators grouped by the fields in Dimensions to calculate the standard deviation.

Variance and standard deviation are  used to measure dispersion. If you want to know whether there is a big difference in contract amount per order between different contract types, you can use variance and standard deviation. The standard deviation of the Temporary fields is the largest, indicating that data in this group are relatively scattered and there is a large difference between the contract amounts.

Variance is the mean of the squared differences between each value and the overall mean, after grouping by fields in Dimensions.