I am trying to show the approximate date at which a measure is expected to reach 0, based on a trendline. I have the trendline displayed, but there is no way that I know of to display the x-intercept. Is there a way to do this?
Here is a solution (indicated with the red reference line):
I used formulae from here but simplified in y=ax+b equation
Your goal is to find the function's zero point:
and convert back to date.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...