Aggregate Values by Attributes
- Author: O.Conrad (c) 2017
- Menu: Table | Calculus
Description
Aggregate Values by Attributes
Parameters
| | Name | Type | Identifier | Description | Constraints |
|---|
| Input | Table | table, input | TABLE | - | - |
| Output | Output | table, output | AGGREGATED | The calculated statistics. | - |
| Options | Aggregate by Field(s) | table fields | FIELDS | - | - |
| Statistics Field(s) | table fields | STATISTICS | - | - |
| Sum | boolean | STAT_SUM | - | Default: 0 |
| Mean | boolean | STAT_AVG | - | Default: 1 |
| Minimum | boolean | STAT_MIN | - | Default: 0 |
| Maximum | boolean | STAT_MAX | - | Default: 0 |
| Range | boolean | STAT_RNG | - | Default: 0 |
| Deviation | boolean | STAT_DEV | - | Default: 0 |
| Variance | boolean | STAT_VAR | - | Default: 0 |
| Listing | boolean | STAT_LST | - | Default: 0 |
| Count | boolean | STAT_NUM | - | Default: 0 |
| Field Naming | choice | STAT_NAMING | - | Available Choices:
[0] variable type + original name
[1] original name + variable type
[2] original name
[3] variable type
Default: 0 |
Command Line
Usage: saga_cmd table_calculus 18 [-TABLE ] [-AGGREGATED ] [-FIELDS ] [-STATISTICS ] [-STAT_SUM ] [-STAT_AVG ] [-STAT_MIN ] [-STAT_MAX ] [-STAT_RNG ] [-STAT_DEV ] [-STAT_VAR ] [-STAT_LST ] [-STAT_NUM ] [-STAT_NAMING ]
-TABLE: Table
table, input
-AGGREGATED: Output
table, output
-FIELDS: Aggregate by Field(s)
table fields
-STATISTICS: Statistics Field(s)
table fields
-STAT_SUM: Sum
boolean
Default: 0
-STAT_AVG: Mean
boolean
Default: 1
-STAT_MIN: Minimum
boolean
Default: 0
-STAT_MAX: Maximum
boolean
Default: 0
-STAT_RNG: Range
boolean
Default: 0
-STAT_DEV: Deviation
boolean
Default: 0
-STAT_VAR: Variance
boolean
Default: 0
-STAT_LST: Listing
boolean
Default: 0
-STAT_NUM: Count
boolean
Default: 0
-STAT_NAMING:
Field Naming
choice
Available Choices:
[0] variable type + original name
[1] original name + variable type
[2] original name
[3] variable type
Default: 0