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.
- 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).