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 y-intercept values should make more sense. Any suggestions/ leads on how to go about doing that?
Trend Line.twbx 13.4 KB
I tried the plotting versus INDEX() and saw that it did change the slope,
and now the y-intercept 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