Median
Overview
The Median macro finds the median value of up to four Value fields. You may optionally specify up to four Key fields.
If you do not specify any Keys, the macro outputs one record containing the global median of each Value. If you specify one or more Keys, they define groupings, and the macro outputs one record per group, with each record containing the median of each value within that group.
Median macro configuration parameters
The Median macro has a single set of configuration parameters.
Parameter | Description |
|---|---|
Key1...Key4 | Optional key fields to define groupings in the data. The macro will output one record per group, with each record containing the median of each value within that group. You may specify up to four key fields.
|
Value1...Value4 | Fields for which the macro will find median values. You may specify up to four value fields.
|
Configure the Median macro
Select the Median icon.
Go to the Configuration tab on the Properties pane.
Optionally, select Key1 and choose a key field to define groupings in the inputdata. The macro will output one record per group, with each record containing the median of each Value within that group. You may specify up to four key fields.
Select Value and choose the numeric field for which to find the median value. You may specify up to four value fields.
Optionally, go to the Execution tab, and then set Web service options.