16.20 - MovingAverage - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

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