REGR_AVGX
REGR_AVGX evaluates the average of the independent variable of the regression line.
Syntax
REGR_AVGX (expression1, expression2) OVER (window_clause)
Remarks
• The dependent variable is expression1. The independent variable is expression2.
• REGR_AVGX makes the following computation after the elimination of NULL expression1-expression2 pairs:
AVG (expression2)
• Without a window clause, REGR-AVGX is a simple aggregate function.