7.00.02 - WMAVG Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
TargetColumns
[Optional] Specifies the names of the input columns for which the weighted moving average is to be computed. The function copies these columns to the output table. Default behavior: The function copies these columns to the output table but does not compute their weighted moving averages.
WindowSize
[Optional] Specifies the number of old values to consider for computing the new weighted moving average. Default: '10'.
IncludeFirst
[Optional] Specifies whether to output the first window_size rows. Because the weighted moving average for the first window_size rows is undefined, the function returns NULL values for those columns. Default: 'false'.