Median - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
This function returns the median value of all the values in each group, the median being the middle value. If the number of values for any group is an even value, the average of the two middle values is returned. Otherwise, the middle value is returned. When dragging a Median element into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Time Series > Median

A Column or other non-aggregate expression can be moved over the (empty-Value Expression) branch of the tree.

The option to compute the median over distinct values only is provided, resulting in the generation of MEDIAN(DISTINCT expression). This option is enabled through the Properties panel. Double-click on Median, or highlight it and click Properties.

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Time Series > Median Properties