I am trying to create a combination chart with the actual numbers as the bars & the "fake" target as the line. The reason why I call it the "fake" target is because the targets are not in the data. I have them as numbers but I am struggling to actually combine them with the actual data.
I have attached an image from Google images of what I am trying to accomplish.
What calculated fields should I use to create the "fake" numbers & have them interact with the "real" actual data?
Looks like you'll need to assign the target numbers against a date - you probably already have this in your spreadsheet (or whatever you're using to store these).
Copy the target numbers with dates into your Tableau workbook. Blend this new data source to your actual numbers, blending on the date fields.
Then build your bar chart, bring in the targets from your pasted secondary source and make sure the "chain" is orange in the dimension list, to show the blend is active.