Last Modified Date: 03 Jan 2019
AnswerTableau returns values like slope of trend line, covariance, R-squared and Pearson correlation coefficient when you add a trend line and then select "Describe Trend Model". For more information about trend lines please see Add Trend Lines to a Visualization.
- Right-click the trend line and select "Describe Trend Models"
- Copy the trend line model equation in a calculated field.
Option 2Use table calculations to calculate the trend line and slope. To view an example, see the attached workbook called trend line generic.twbx.
Option 3In Tableau 10.2 it is also possible to use the COVAR() function to create a calculated field which returns the slope of a trend line. For more information about how this can be done please see Covariance, Trend Lines, Correlation Coefficient R and R-Squared in the Community.
Additional InformationAdditional information about Trend Lines can be found in the following third party article: Interacting with your Trend Line in Tableau (Part 1).
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials