The MovingAverage function computes average values in a series, using the specified moving average type.
Moving Average Type | Description |
---|---|
Cumulative Moving Average | Computes cumulative moving average of value from beginning of series. |
Exponential Moving Average | Computes average of points in series, applying damping factor that exponentially decreases weights of older values. |
Modified Moving Average | Computes first value as simple moving average. Computes subsequent values by adding new value and subtracting last average from resulting sum. |
Simple Moving Average | Computes unweighted mean of previous n data points. |
Triangular Moving Average | Computes double-smoothed average of points in series. |
Weighted Moving Average | Computes average of points in series, applying weights to older values. Weights for older values decrease arithmetically. |
- This function requires the UTF8 client character set for UNICODE data.
- This function does not support Pass Through Characters (PTCs).
For information about PTCs, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.
- The ORDER BY clause supports only ASCII collation.
- The PARTITION BY clause assumes column names are in Normalization Form C (NFC).