5 (Very Difficult) since I haven't read the solution and haven't figured it out.
I am sure it will be 1 (Very Easy) when I am familiar with the recipe
May I ask if this is done within a single worksheet?
I fiddled with various ways, till I gave up and did it the way I have done others in the past. But, I thought, "Jonathan Drummey must have a better, cleaner way!" So, I looked at your solution, and it was the same as mine. Surprise!
I give it a difficulty of 3, only because of trying lots of alternatives, and fiddling to get the alignment perfect.
I LOVE brain teasers. Keep 'em coming!
I'm not going to say.
Thanks for continuing this awesome idea Jobathan!
I rate this at a 4 since the possible solutions may not be immediately obvious and seem to require a bit of setup and maintenance.
Thank you Jonathan for melting my brains :-)
Rate it at 4.9 'cause I like the number.
Here below is my last attempt to make it.
Definitely not the right one, but I couldn't make it better.
Remind me the old days of "clear pixel gif" HTML tricks.
headers down below_YF.png 33.6 KB
Cool.Thanks for sharing Jonathan..I rate it at (4)
Oops, I forgot to put posting the solution into my calendar! Here's the solution from Re: BAR Chart modification:
The problem here is that when we put multiple discretes on the Columns Shelf, Tableau will only put the right-most pill on the bottom and the rest go on the top. However, in this case to get two bars for each Region we need the right-most pill to be something that will segment the bars, not the Region. We can also build a grouped bar chart using continuous measures, however that runs into the problem that Tableau will draw the axis legend and that's not something that we can edit.
The solution here is to use a dashboard with a worksheet for the data and a second worksheet for the header, with a filter that applies to both. It could be built with two worksheets and a spacer blank object a couple of layout containers, in this case I used two worksheets. One has the bars with the headers turned off *and* the axis legend made slightly larger:
The other uses Region on Columns & the Text Shelf, with some formatting to get column borders and the font to look like a header:
Then the two worksheets were put in a floating layout and fiddled with until the are precisely positioned.
Thanks to everyone who participated!
headers down below end.twbx 972.7 KB