intercept — aggregate function to return the value where a best-fit linear regression line intersects the Y axis.
For the data set of fields x and y for all rows in the aggregate's window, a best-fit linear regression line is calculated, then the function returns the value at which the line intersects the Y axis. The method used to find the line that best fits a group of points is called least squares or linear least squares.
If the query returns no rows to the aggregate's window, the function returns
null. If the query returns a row count of 1 or −1, the
result is also null.
This LiveView aggregate function is based on the intercept aggregate function in the StreamBase expression language.