
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

6. Re: Trend Line Calculation
Ron Chipman Jun 6, 2019 12:36 PM (in response to Briann Tisdale)Hi Briann,
Glad to see you were getting something to work. I have a question, that apparently is so simple, it is glassed over by all knowledge articles as they dive into the deep stats around it.
When you say you set X = 'dates', how are you representing that numerically? I have a trend model equation : ln(per min concurrency) = 13.2465*(Minute(CreateDate)) + 577823, but I'm not sure what values I can actually insert to represent (June 7th @ 12:30 PM). Do we use unixtime? Something else? How do I translate minutes into a generic number in such a way that I can use it in the formula?
Thanks!
Ron