RegressionIntercept
This function isn’t compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.
The RegressionIntercept function calculates the y-intercept of the linear regression line. This provides you with the predicted value of a variable when the other variable is equal to zero.
The RegressionIntercept function is an aggregate function.
Aggregate functions evaluate one or more rows of data and return a single value.
In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.
In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.
To learn more about using aggregate functions, see Building complex formulas with grouped data.
Syntax
Function arguments
Notes
- The function returns null if the arguments used provide only a single data point.
Example
A table contains an AdSpend column (tracking monthly advertising spend) and a Revenue column (tracking month revenue). You can use the RegressionIntercept function to find what the baseline monthly revenue is when the monthly advertising spend is zero.