1 of 1 people found this helpful
You could either do it inside of a dashboard, where you have the bar chart and the text table next to each other and use the bar chart sheet as a filter, or you could go the viz-in-tooltip route. What version of desktop are you using?
Tell me more about this.
Rachel Hughes has "Long Response" AND "Price" in the coded section. Is her row represented on two separate bars on Sheet 1? (One for each code?)
A sample workbook would really help you here.
Yep, different coded responses (since she mentioned both a long response time and price concerns in this case) are separated with the "|" symbol. The separate bars on Sheet 1 are not each customer responses, but different codes like "Long response" or "Price" since that's what we are counting.
Thanks for the video, I will have to check it out.
OK, that's what I figured.
So you can't use the coded field as an action filter because you'll only get exact matches.
I'm looking for a sample workbook because I want to see how you did the bars. We might be able to leverage that to bring up a sheet with a viz that contains the value in the [Coded] column.
Would it be alright if I have the data pivoted? With Pivot Field Name describing the department it's located in, and the Values each being separate potential coded responses?
I'll be able to provide a sample workbook tomorrow if this isn't sufficient enough information.
I suspect a pivot (or unpivot) will be the key to making this work.
Pivoted or not, probably doesn't matter to what you upload here.
My gut feel is that this will be easier having separate [Coded] rows for each customer. It's easier to filter on things that way. But we can also create a concatenated calc if that's also a way you need to see the data presented.