MovingAverage Function | Teradata Vantage - 17.05 - MovingAverage (SQL Engine) - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K

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