Average - 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

The standard average function is supported, taking a single expression argument and generating AVG (expression). The function returns a value of type float, with the exception that a value of type date is returned as the average of a date expression. When dragging an Average into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Average

Columns and/or other non-aggregate expressions can be moved over the (empty) branch of the tree.

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

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Average Properties