-
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 right-click 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 BeardenFeb 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 R-Squared
Best,
David