I need to create a chart with values that have unique targets. The targets are not in my data set. I tried creating a spreadsheet with the targets, but I got an error when trying to connect the two sources. Not sure what to do. From my data source, I will be using a dimension (Item 1 and Item 2), a calculated field to distinct count, another dimension to get the item's totals, and a date field. As mentioned earlier, the target is not in the data source. I am using Tableau 2019.3 version for this and unfortunately due to the nature of the content I cannot share a workbook. Thank you for your help.
Here's and example of what I am trying to visualize
Item1 Total: 2 Target: 2 Month: January
Item 2 Total: 5 Target: 7 Month: January
Item1 Total: 3 Target: 4 Month: February
Item 2 Total: 2 Target: 7 Month: February
Item1 Total: 3 Target: 5 Month: March
Item 2 Total: 4 Target: 7 Month: March
Thanks. Attached is the above data in Excel.
