Tabulations

You can apply simple tabulations to a chart directly in the chart builder.

Click Tabulations () for a drop-down list of tabulations you can perform in the chart builder.

Tabulations you can perform in the chart builder include the following:

Counts The number of rows in each group. 
  • The number of rows includes those with N/A values.
Uniques Count The number of unique values for each group.
  • If a group contains N/A values, those rows are ignored (i.e., the result is the number of unique non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.
Average The average for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the average of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
Standard Deviation The standard deviation for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the standard deviation of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
Sum The sum of each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the sum of the non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.