
1. Re: Linear Trend Line: Utilizing Indices
Dennis Kwon Jun 30, 2016 10:30 AM (in response to Dennis Kwon)I figured that since no one has responded and I'm still relatively new with Tableau, I've attached a simple workbook to make the problem more clear .
In the workbook you'll see the 2 linear trend lines:
Trend line Equation 1:
Avg. Value = 1440*Date and Time + 6.12252e+07
Trend line Equation 2:
Avg. Value = 10080*Date and Time + 4.28576e+08
I want to use the indices rather than the serial value of the date/time. By doing that my yintercept values should make more sense. Any suggestions/ leads on how to go about doing that?

Trend Line.twbx 13.4 KB


2. Re: Linear Trend Line: Utilizing Indices
swaroop.gantela Jun 30, 2016 12:05 PM (in response to Dennis Kwon)Dennis,
I tried the plotting versus INDEX() and saw that it did change the slope,
and now the yintercept was 0 for Trend 1 and positive for Trend 2.
Not sure if that is correct. Also saw that INDEX() shifted the graphs so that
they no longer cross where they once did. Is the temporal crossing point important?

209960Trend Line.twbx 54.4 KB
