Aggregate column

Table window	Columns menu
Aggregate Column

Aggregate the values of a column in the current table. The following aggregation functions are available: Average, Count, Maximum, Median, Minimum, Predominant, Standard deviation, Sum.

All aggregation functions can be used to aggregate the values of a whole column: you obtain one output value. For all records, the same aggregation value will appear.
All aggregation functions can be used to aggregate values in a column per group: use a 'group by' column. Then, for all records that have the same class names or IDs in the selected 'group by' column, the same aggregation value will appear.
The Average, Median, Predominant and Standard Deviation functions can be used to calculate weighted averages, etc.: use a weight column.

If you do not select a 'group by' column, you will obtain one output value.
If you also select a 'group by' column, you will obtain one aggregation value per group.

You can choose to create a new dependent column in the current table or to create a new dependent column in another table.

Dialog box options:

Column:	Select a column that contains the data that you want to aggregate. This will usually be a column with a value domain.
Function:	Select an aggregation function: Average, Count, Maximum, Median, Minimum, Predominant, Standard Deviation, or Sum.
Group by:	Select this check box if you want to obtain aggregation values per group. Subsequently select the 'group by' column. This is usually a column with a class or ID domain; you can also select a column with a Bool domain. Clear this check box if you want to aggregate the values of a whole column.
Weight:	For the functions Average, Median, Predominant and Standard Deviation, you can select this check box if you want to use a weight column to calculate weighted averages, etc. A weight column is a column with a value domain. Clear this check box if you do not want to use a weight column.
Output table:	When you use a 'group by' column, you can create a new dependent column in another table, that table needs to have the same domain as the 'group by' column.
Output column:	Type a new column name. A dependent column is created.

The Column Properties dialog box will appear.

Tips:

All aggregation functions expect a value column on which the aggregation should be performed; however, the functions Count, Median and Predominant also work on a class or ID input column.
You can also aggregate values by typing an expression on the TabCalc command line. For more information, see Aggregate functions.

Table window

Aggregate Column