1.1 - 8.10 - WeightedMovAvg Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
TargetColumns
[Optional] Specify the names of the input columns for which to compute the weighted moving average. 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] Specify the number of old values to consider for computing the new weighted moving average.
Default: '10'
IncludeFirst
[Optional] Specify 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'