
1. Re: How to Create Scatter Plot  Time vs Data?!
Shawn Wallwork Aug 5, 2013 5:02 AM (in response to Nick Bishop) 
2. Re: How to Create Scatter Plot  Time vs Data?!
Nick Bishop Aug 5, 2013 5:02 PM (in response to Shawn Wallwork)Hi Shawn,
Thanks for the reply.
I have done a mockup example of my question in this Tableau link. There is capital cost, and a running cost (energy cost). From these data pairs, I have created calculated fields of the netpresent value (NPV) at 5, 10, 15, 25 & 50 years.
I would like to do a netpresent value scatter plot on this coststream, with years on the xaxis and the NPV on the yaxis. Excel would have allowed me to plot the 5/10/15/25/50 NPV calculations as connected line scatter plots, but I cannot find a way of doing this.
Note my actual data set is much longer, with hundreds of capital cost/energy cost pairs.
Thanks again.

3. Re: How to Create Scatter Plot  Time vs Data?!
Shawn Wallwork Aug 5, 2013 5:21 PM (in response to Nick Bishop)Nick, thanks for the sample workbook. You talk about wanting "years on the xaxis" but I'm not seeing a "years" field. So what is it we should put on the xaxis? I suspect we could do a few contortion and extract years from the fields you have, but I'm also hesitant work through these calculation without knowing we're really going in the right direction.
If you could create the Excel viz you are trying to emulate and post at least a screen shot, then we'll better understand what you're trying to accomplish. Please use the same data to create the Excel viz as you provided in the Tableau workbook.
Thanks,
Shawn

4. Re: How to Create Scatter Plot  Time vs Data?!
Nick Bishop Aug 5, 2013 5:47 PM (in response to Shawn Wallwork)Hi Shawn,
Thanks for your help. One problem is I want to calculate NPVs inside Tableau so I can adjust interest rates etc and see responses.
Because the capital cost & energy cost data isn't like on a year by year basis, I don't know how a "Years" field (while maybe required), would work to create to map against the capital & energy costs.
I have attached a screenshot of how I would do it in Excel, with a xaxis of 5,10,25,50 years on a connecteddot scatter plot. Even if I name 5YrNPV "5", and 10YrNPV "10" etc in Tableau it still won't accept it as a numerical xaxis dataset, so I'm out of ideas.