1.1 - 8.10 - SimpleMovAvg 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 simple moving average.
Default behavior: The function copies all numeric input columns to the output table.
IncludeFirst
[Optional] Specify whether to output window_size rows. Because the simple moving average for the first window_size rows is undefined, the function returns NULL values for those columns.
Default: 'false'
WindowSize
[Optional]
Specify the number of previous values to include in the computation of the simple moving average.
Default: 10