Good Morning Dwight,
You should be able to drag other fields to the data area of the chart, then Tableau will title them automatically to match the field name. I took some variations on your data in your example to make a '2015' and '2016' and built the other calculations off of those. Getting the mark at the end of the chart is a little beyond my skill level at the moment, but color can be used pretty easily to offset the green/red. Jonathan Drummey made a "Floating Kpis dashboard" which might get the dots where you would like them.
I have no idea how to get a good link to a tableau public workbook. Everyone gets something so nice and short and stands out so well. Here goes:
Hopefully, this works and helps. I don't have the best luck with links.
Hi Chris, the example on Tableau Public has Dimensions on Rows. My Workbook has Measure Names on Rows, which is the way I need the View to be designed. I think there's a significant diff between Dims on Rows and Measure Names. Thanks for your assistance
Is this more exact to your specifications?
I matched the formatting to your original specifications as well as I could. I think you'll be stuck with using multiple sheets unless you can reformat your data. There are a lot of other folks on here more skilled than I am with Crosstabs though.
Do me a huge favor Chris and remove the embedded image in Workbook you just posted and delete the image I originally included in the Post. I replaced the image and I don't want others viewers of this post to see that image. Thanks. BTW, your suggestion is right along the lines of what I need, but reshaping the data isn't an option. Great idea, I see you're an up and coming guru!
I think 'reshaping' the data might be simple depending on how you'd need to go about it. Tableau has a built in pivot option which might be useful in setting up the data in a fashion that you might need. That way, your original data remains unaltered. If you need the data in both formats, you should be able to connect to the same data twice and just modify the one to suit your needs.
1 of 1 people found this helpful
Hey Chris, this has been a great exchange. I'm talking with Tableau and let me say that there are two options available to accomplish what I want to do. The first is the solution you provided, so I'm gonna give you that. The second I'm getting from a guru "hidden under the stairs"...LOL within the walls of Tableau. It's a really involved workaround, but it ultimate achieves the same result you achieved by reshaping the data.