Arguments - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
Argument Category Description
TargetColumns Optional Specifies the names of the input columns for which the simple moving average is to be computed. If you omit this argument, then the function copies all numeric input columns to the output table.
IncludeFirst Optional Specifies 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. The default value is 'false'.
WindowSize Optional Specifies the number of previous values to include in the computation of the simple moving average. The default value is 10.
The SMAVG function treats the schema names, table names, and column names as case-insensitive arguments. If any of these arguments contain capital letters, you must surround each one of them with double quotation marks. For example:
TargetColumns ('"City"', 'date')