
1. Re: Trend Line Calculation
Briann Tisdale Aug 7, 2012 10:40 PM (in response to Briann Tisdale)bump

2. Re: Trend Line Calculation
Briann Tisdale Aug 16, 2012 6:40 PM (in response to Briann Tisdale)My question was answered by Tableau Sales Consultant.
The Trend line metadata is currently not available to the user. You can see the data when rightclick on the line and selecting "Describe Trend Line", but results are not available.
My workaround will be to replicate the 'Value' via a Calculated Field and use it to determine EOY projections. Once completed, I will post and share.
Briann

3. Re: Trend Line Calculation
Briann Tisdale Aug 30, 2012 11:23 AM (in response to Briann Tisdale)1 of 1 people found this helpfulI was able to calculate the metadata needed by using a Linear Regression Analysis formula via SQL, prior to uploading Data in to Tableau.
Using various queries, I shaped my data to where X = 'Dates' and Y = 'Running Sum Total' then applied the formula below
Round((Avg([X]*[Y])Avg([X])*Avg([Y]))/VarP([X]),6)) AS RegressionCoefficient
A stronger Tableau user could create a calculated field to accomplish the same task; I'm not there yet. Please let me know if someone figures it out, Thanks
Briann

4. Re: Trend Line Calculation
Lauren Bearden Feb 15, 2016 5:39 PM (in response to Briann Tisdale)Hi Briann,
I was just looking for the same answer, and found this Interworks blog article. I thought it might be helpful for you as well. It tells you how to do trend line analysis with Tableau and R.
Lauren

5. Re: Trend Line Calculation
David Kuder Jan 11, 2017 2:54 PM (in response to Briann Tisdale)Briann,
See if this is what you're looking for:
Covariance, Trend Lines, Correlation Coefficient R and RSquared
Best,
David