I have a measure (tshirts) that I would like to track on a line graph against a calculated field that represents the tshirt goal for Q2 2013. I have created the calculated field using this calculation:
68861 + MAX(DATEDIFF('day',#April 1, 2013#,[DateAson]))*12.51648
Adding 12.51 tshirts per day (from total of 68861 on April 1) will get us to our Q2 goal of 70,000 tshirts on June 30, 2013. DateAson is the date that feeds through from the DB for every record.
I would like these lines to show up on the same graph. I can't get it to work with a reference line.
If you can plot the calculation as it exists, you could plot it on a secondary dual axis (remember to sync the axis)
Great idea. Thank you, Alex.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...