CumulativeMovAvg Function | Teradata Vantage - CumulativeMovAvg (ML Engine) - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

The CumulativeMovAvg function computes the cumulative moving average of a value from the beginning of a series.

In a cumulative moving average, the data are added to the data set in an ordered data stream over time. The objective is to compute the average of all the data at each point in time when new data arrived. The cumulative moving average computes the arithmetic average of all the rows from the beginning of the series, using this formula:

CumulativeMovAvg = SUM(a1, ..., aN)/N

N is the number of rows from the beginning of the data set.