The group commands let you group records based on identical or similar values. Depending on the command, you can group text values, numbers, or dates, or a combination of these types.
Command descriptions
| Command | Description |
|---|---|
|
Groups records into aging periods based on values in a date or datetime field. Counts the number of records in each period, and also subtotals specified numeric fields for each period. |
|
|
Groups records based on identical values in a character or numeric field. Counts the number of records in each group, and also subtotals specified numeric fields for each group. |
|
|
Groups records into clusters based on similar values in one or more numeric fields. Clusters can be uni-dimensional or multidimensional. |
|
|
Groups records based on identical combinations of values in two or more character or numeric fields, and displays the resulting groups in a grid of rows and columns. Counts the number of records in each group, and also subtotals specified numeric fields for each group. |
|
|
Groups records based on values in a character or numeric field, counts the number of records in each group, and displays the groups and counts in a bar chart. |
|
|
Identifies statistical outliers in a numeric field. Outliers can be identified for the field as a whole, or for separate groups based on identical values in one or more character, numeric, or datetime key fields. |
|
|
Groups records into numeric intervals based on values in a numeric field. Counts the number of records in each interval, and also subtotals specified numeric fields for each interval. |
|
|
Groups records based on identical values in one or more character, numeric, or datetime fields. Counts the number of records in each group, and also subtotals specified numeric fields for each group. |
