TD_MAMEAN Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2026-03-23
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
SERIES_SPEC
An input source with the univariate series instances to be processed by the function. The data type is REAL.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
FORECAST_PERIODS Integer Number of periods to forecast. It is an integer between 1 to 32000.
ALGORITHM Enum, String Type of forecast algorithm to use.
  • MA: Moving Average
  • MEAN: Mean average
  • NAIVE: Naive, also known as random walk forecast
PREDICTION_INTERVALS Enum, String [Optional] The confidence level for the prediction, such that 85 means 85% confidence.
  • NONE
  • 85
  • 90
  • BOTH

Default is BOTH 85 and 90.
FIT_METRICS Integer [Optional] Flag to generate the secondary result set that contains the model metadata statistics. A value of 1 means generate the secondary result set. A value of 0 means do not generate the secondary result set. The default is 0.

The generated result set is retrieved using TD_EXTRACT_RESULTS against the analytical result table containing the results.
RESIDUALS Integer [Optional] Flag to generate the tertiary result set that contains the model residuals. A value of 1 means generate the tertiary result set. A value of 0 means do not generate the tertiary result set. Th default value is 0.

The generated result set is retrieved using TD_EXTRACT_RESULTS against the analytical result table containing the results.
K_ORDER Integer [Dependencies: Only used with ALGORITHM(MA), and required.] Integer between 1 to 32000.
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
No OUTPUT_FMT options are available for this function.