Record Aggregation

Author: O.Conrad (c) 2024
Menu: Table | Calculus

Description

This is a simple tool to aggregate the values of the selected attribute by statistical means for the given number of records.

Parameters

	Name	Type	Identifier	Description	Constraints
Input	Table	table, input	`INPUT`	-	-
Output	Aggregation	table, output	`OUTPUT`	-	-
Options	Field	table field	`FIELD`	-	-
	Order by...	table field	`INDEX`	-	-
	Identifier	table field	`IDENTIFIER`	-	-
	Number of Records	integer number	`LENGTH`	The total number of records to be taken into account for aggregated statistics.	Minimum: 2 Default: 10
	Mean	boolean	`MEAN`	-	Default: 1
	Median	boolean	`MEDIAN`	-	Default: 0
	Minimum	boolean	`MIN`	-	Default: 0
	Maximum	boolean	`MAX`	-	Default: 0
	Standard Deviation	boolean	`STDV`	-	Default: 0
	Lower Standard Deviation	boolean	`STDV_LO`	-	Default: 0
	Higher Standard Deviation	boolean	`STDV_HI`	-	Default: 0

Command Line

Usage: saga_cmd table_calculus 20 [-INPUT ] [-OUTPUT ] [-FIELD ] [-INDEX ] [-IDENTIFIER ] [-LENGTH ] [-MEAN ] [-MEDIAN ] [-MIN ] [-MAX ] [-STDV ] [-STDV_LO ] [-STDV_HI ]
  -INPUT:     	Table
	table, input
  -OUTPUT:    	Aggregation
	table, output
  -FIELD:     	Field
	table field
  -INDEX:     	Order by...
	table field
  -IDENTIFIER:	Identifier
	table field
  -LENGTH:    	Number of Records
	integer number
	Minimum: 2
	Default: 10
  -MEAN:      	Mean
	boolean
	Default: 1
  -MEDIAN:    	Median
	boolean
	Default: 0
  -MIN:       	Minimum
	boolean
	Default: 0
  -MAX:       	Maximum
	boolean
	Default: 0
  -STDV:      	Standard Deviation
	boolean
	Default: 0
  -STDV_LO:   	Lower Standard Deviation
	boolean
	Default: 0
  -STDV_HI:   	Higher Standard Deviation
	boolean
	Default: 0