Output Columns
Field Name | Description and Valid Values |
---|---|
OperationOfInputFieldName | Contains the result of a calculation. Group Statistics creates
one output field for each 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 increments accordingly. |
ComputationalCountOperationOfInputFieldName | 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.
|
Status.Code | Reason for the processing failure. The status codes available are:
|
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.