MovingAverage

The moving average table operator computes the moving average over a number of points in a series based on the selected MavgType.

Options

Alpha
Specifies the damping factor, a value in the range [0, 1], which represents a percentage in the range [0, 100]. For example, if alpha is 0.2, then the damping factor is 20%. A higher alpha discounts older observations faster. The default value is 0.1.
IncludeFirst
Specifies whether the first START_ROWS rows should be included in the output or not.
MavgType
Specify the moving average type that needs to be used for computing moving averages of TargetColumns.
StartRows
Specifies the number of rows at the beginning of the time series that the function "skips" before it begins the calculation of the exponential moving average. The function uses the arithmetic average of these rows as the initial value of the exponential moving average. The value n must be an integer. The default value of n is 2.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
TargetColumns
Specifies the input column names for which the moving average is to be computed. If you omit this argument, then the function copies every input column to the output table but does not compute moving average.
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.
WindowSize
Specifies the number of previous values to include in the computation of the simple moving average. The default value is 10.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
Specifies the name of the table that contains the columns

Output Ports

Icon
output of MovingAverage

Nodes

Extensions

Links