Are you trying to show all the responses to the survey, but just highlight the selected one? You could do that with a LOD - check out the Comparative Sales example in this post: A Deeper Look at LOD Expressions—Week 2 | Tableau Software
If not, then Rody is right - we need more details.
I'm looking at survey results from 150 people. The responses are multiple choice. In the workbook, I'd like to only highlight the bar (or number in a table) so it's clear which option we selected. (The rest of the bars = white, ours = purple). I am trying to figure out how to do that. I've tried annotating, but it seems clumsy.
Does this clarify?
I am looking to change one bar to a different color, but it isn't clear how to do that using this example.
Download the workbook and walk through the example (actually, you don't need an LOD). The short high level detail is this:
Create a parameter for selecting your response.
Then create a calculated field that has the response field = parameter.
Drag that calculated field to the color shelf, and have all the responses in the row field (and either the text of the response or the count of the response in the Abc field, depending on what you're trying to do - it works best with the sum of responses as a bar graph)
Change the colors to have True be your bright highlight color and False will be white (you have to customize your palette to get white) or light grey)
Then you can select the response from the parameter and the response (count or text) will highlight. The row header will not highlight, which is why you want to have the text/count and *that* is what highlights.
Does that help, or did I confuse even more?
I downloaded the workbook. Since I haven't yet used parameters, It'll be new territory for me.
There are so many potential responses to the survey (the response options change for each question) that it might actually take longer to do it this way. (Scratching my head..). I was hoping there was just a way to right-click a specific bar and change the color of that bar - do you know of anything like that?
In your dataset....do you have a column(s) that designate the option you selected?
questionID participantID response selectedResponse 1 a aa aa 1 b aa aa 1 c bb aa 1 d dd aa 1 e ff aa
If so, then we can just do a calculated filed like
IF [response] = [selectedResponse] THEN 'Purple' ELSE 'White' END
If, on the other hand, this data is in another spreadsheet/table, then perhaps you can try joining them together on whatever the identifier is for a particular Question.
No, I have a dataset with all answers and a report (PDF) with our responses, unfortunately.
I found the row that is ours, however (silly that I didn't think of that before!) and created an ID for us vs. used "Other". When I moved the field to the color mark, only a tiny piece of the bar (the percentage of total responses) turned a different color. Not finding an easy way around this.
Any advise would be great.
Not sure I entirely understand.
Can you provide a screen shot of you viz? I am curious about your pill arangement/chart choice.
Don't you think if you display the entire bar in purple, the color indicator will no more holds good and how will you determine which portion is from other and UW HFS. One possible way is, color the bars using Q5.Does your department filed and drop the universe department under the label.
Hope this will help you.