Output Columns

Field Name	Description / Valid Values
<Operation>Of<InputFieldName>	Contains the result of a calculation. Group Statistics creates one output field per operation and names the field based on the operation and field. For example, the default field name for a `Sum` operation performed on a field named `Population` would be `SumOfPopulation`.
<Value>_<Operation>	Contains the result of a pivot, where `<Value>` is one of the values in a pivot column and `<Operation>` is the operation performed on the column. For more information, see Creating a Pivot Table.
GroupCount	Indicates the number of records in the group.
GroupID	A unique number assigned to each group sequentially. The first group has a GroupID value of 1, the second has a value of 2, and so on.
ComputationalCount<Operation> Of<InputFieldName>	Indicates the actual number of records in a group on which the operation is performed. For example, for the operation `Average` performed on the `Salary` column, the column `ComputationalCountAverageOfSalary` is generated.
Status	Reports the success or failure of the Group Statistics calculations. null Success F Failure
Status.Code	Reason for failure, if there is one. The status codes available are: UnableToDoGroupStatistics The Group Statistics stage was unable to perform its calculations. Error calculating percentile value The percentile value could not be calculated using the input data provided.
Status.Description	A verbose description of the error. The input field value could not be converted to the field type. It might be overflow! A number in an input field is larger than the data type allows. Try converting to a data type that supports larger numbers, such as double.

Group Statistics Example

This input data shows the number of customers you have in certain counties. The data also shows the U.S. state in which the county is located (MD, VA, CA, and NV), as well as the region (East or West). The first row is a header record.

Region|State|County|Customers
East|MD|Calvert|25
East|MD|Calvert|30
East|MD|Prince Georges|30
East|MD|Montgomery|20
East|MD|Baltimore|25
East|VA|Fairfax|45
East|VA|Clarke|35
West|CA|Alameda|74
West|CA|Los Angeles|26
West|NV|Washoe|22

If you wanted to calculate the total number of customers for each region, you would define the Region field as a row in the Operations tab. For the operation, you would perform a sum operation on the Customers field.

The result:

Region|SumOfCustomers
    East|210.0
    West|122.0

Note: This example shows a basic group statistics operation using only rows to aggregate data. You can also create a pivot table, which aggregates both rows and columns, by specifying a column to group by in the Operations tab.

For more information about creating a pivot table, see Creating a Pivot Table.