I'll play more detail tomorrow
Very nice. Very glad you posted this, as I've never seen this type of solution with Measure Names/Values in the past. This certainly was beyond me, and something I had not considered for this particular worksheet.
Where did you pick that up from Michel Caissie (or did it just come to you now)? It makes total sense, now that I see it, but I wonder why I haven't seen it before.
Thank you VERY much for jumping in - I worry about misrepresenting Tableau when I'm the only one responding.
I still think Reshaping the data is going to be the ideal solution, since I'm sure there is more to this report than just this one sheet. And since it's survey data, reshaping is going to benefit the OP in many other scenarios.
I don't believe this will work if you have 8 color tests. But perhaps I'm wrong on that as well! I believe this will only work if you only want to color on the one measure in the view.
To pull multiple pills to the color shelf from the data window, I typically hold CTRL + SHIFT while pulling the fields into the view. Michel suggested holding CTRL while selecting both, and then right-click dragging them into the view (I just confirmed that both methods work for me)
I don't remember exactly when i saw that i could bring 2 dimensions on a color shelf but from there i went on using the Measure Names Dimension with a Color classification to accomplish this kind of requirement. When there is not to much measures to color, it`s easier than going with a multi-axis solution.
I have an Idea opened so we could do the same with the Shapes.
Vladimir, to do it with multiple measures follow the instructions in this post.
And to drag both, select both with Ctrl then right-click and drag (not left click)
I use the multiple dimension technique often, but had never considered it with this Measure Names/Measure Values setup.
Can you post a workbook showing it working for each measure for this data? I think that would help both me and the OP.
I'm having trouble even re-creating it for one measure in my own work:
I did it for Decision and Discovery since both had the color classification done.
I modify the color classification to return not only the color literal but the measure name along with the color. So for Discovery it`s then 'DiscGreen'... elseif... 'DiscRed'...else 'DiscBlack' and for Decision it's
then 'DecGreen'... elseif... 'DecRed'...else 'DecBlack'.
Next i created a new calculation [Color] which is the concatenation of all the color classifications.
Next I bring Measure Names and [Color] on the color shelf .
When editing the color, i check the Measure name and set the color accordingly.
If we look the first combination Avg...Discovery the corresponding color is DiscBlack, on the second it's DiscGreen.
So we can set each color for each measure.
Be aware that if the data doesn't produce all the possible combinations and a new one appear in the future, it will get a random color and you will have to set change it manually.
Book2ed mc.twbx 743.6 KB
Thanks, this is what I suspected (I think). Still quite a lot of manual work to get the desired result (Manually setting the colors in the legend to match what we want, correct?). I was hoping you'd found a way to generate those colors automatically based on the results As it was not clear in the original example whether you had manually set those colors up or if Tableau generated them for you)
Reshaping the data is certainly ideal for working with this type of Survey data, whenever possible, but I am glad to know this is at least possible for those users who cannot reshape (although I don't know of any scenario where reshaping would be impossible--it's just a learning curve to get there)
Thanks again for posting this. I'm on my cell so it's possible I misunderstood your latest reply but I'll take a look later to be certain I understand what you've done.
Cheers to all, and happy to have been shown something new today!
Yes , for sure this solution is good with few measures to color and ideally only 2 colors per measure.
With 8 measures and 3 colors , it can generates 3exp8 possible combinations.
In this case, if reshaping is not an option, it would probably be better to go with one axis on the row shelf per measure. Each axis will have it's own color shelf.