Types of metrics
The Metric dropdown list in the Group Metric panel contains a number of group metrics from which you can choose.
You can choose from the following types of group metrics in the Metric dropdown list. These metrics correspond to the most commonly used g_functions in Macro Language.
Average  The average of the data in the selected Data column for
each group. This is similar to using the g_function g_avg . (numeric
columns only)

Weighted average  The average of the data in the selected Data column for
each group, weighted by the Weights column for each group. This
is similar to using the g_function g_wavg . (numeric columns
only)

Sum  The subtotal of the Data column for each group. This is
similar to using the g_function g_sum . (numeric columns only)

Sum of squares  The sum of squares of the Data column for each group. This
is similar to using the g_function g_sumsqr . (numeric columns
only)

Product  The product of the Data column for each group. This is
similar to using the g_function g_prod . (numeric columns
only)

Maximum value  The highest number in the Data column for each group. This
is similar to using the g_function g_hi . (numeric columns
only)

Minimum value  The lowest number in the Data column for each group. This
is similar to using the g_function g_lo . (numeric columns
only)

Median value  The median of the Data column for each group. This is
similar to using the g_function g_median . (numeric columns
only)

Mode value  The mode of the Data column for each group. This is
similar to using the g_function g_mode . (numeric columns
only)

Standard deviation  The standard deviation of the Data column for each group.
This is similar to using the g_function g_std
(numeric columns only)

Weighted Standard deviation  The standard deviation of the Data column, weighted by
the Weights column, for each group. This is similar to using
the g_function g_wstd . (numeric columns only)

Variance  The variance of the Data column for each group. This is
similar to using the g_function g_var . (numeric columns only)

Weighted variance  The variance of the Data column, weighted by
the Weights column, for each group. This is similar to using
the g_function g_wvar . (numeric columns only)

Correlation  The correlation between Column A and Column
B for each group. This is similar to using the g_function
g_cor . (numeric columns only)

Covariance  The covariance of Column A and Column
B for each group. This is similar to using the g_function
g_cov . (numeric columns only)

Count  The number of rows in each group. This is similar to using the g_function
g_cnt .

Count of unique values  The number of unique values in the Data column for each
group. This is similar to using the g_function g_ucnt .

Count of nonN/A values  The number of nonN/A values in the Data column for each
group. This is similar to using the g_function g_valcnt . 
Count of N/A values  The number of N/A values in the Data column for each
group. This is similar to using the g_function g_nacnt . 
Dot product  The dot product of Column A and Column
B for each group. This is similar to using the g_function
g_dot .

Logical AND  Returns a boolean value indicating whether all values in the
Data column within a given group are 1 (true). This is similar
to using the g_function g_and .

Logical OR  Returns a boolean value indicating whether any value in the
Data column within a given group is 1 (true). This is similar
to using the g_function g_or .
