MLINREG Function Syntax | Teradata Vantage - MLINREG Function Syntax - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category
Teradata Vantageā„¢
MLINREG ( value_expression, width, sort_expression [ ASC | DESC ] )

Syntax Elements

value_expression
The expression cannot contain any ordered analytical or aggregate functions.
width
The number of previous rows to be used in the computation.
The value is always a positive integer literal.
The maximum is 4096.
sort_expression
A column expression that defines the independent variable for calculating the linear regression.
For example, MLINREG(Sales, 6, Fiscal_Year_Month ASC), where Sales is the value_expression, 6 is the width, and Fiscal_Year_Month ASC is the sort_expression.
The data type of the column reference must be numeric or a data type that Vantage can successfully convert implicitly to numeric.
ASC
Ascending sort order.
DESC
Descending sort order.