I have a survey on employee satisfaction that will be distributed to 14,000 individuals within two weeks. Once I close the survey (SurveyMonkey), I intend to download the data to Excel, and then bring it into my Tableau account. There are a handful of demographic questions (ex job type, position, tenure) and satisfaction questions, some of which I expect positive responses (ex good compensation, benefits, work schedule) and others that I expect negative responses (ex teamwork, supervisor's ability, etc). For a multitude of reasons, I want to embed a Tableau dashboard on our Intranet homepage and allow all employees to view the results (there will be filters to allow employees to view results by demographics). Rather than list only the highest scoring (weighted toward negative responses) responses, I would like to display the top 5 negative scoring responses and the top 5 positive scoring responses - and this would change based on the filter setting. I'm using packed bubbles graph. I'm new at Tableau and would appreciate any guidance creating this graph. I've dummied up an example on my Public account - (see Kevin Jablonski) - | Tableau Public
We can use the option "Combine Sets"
1) Create a set for Top another for Bottom.
2) Then right click on One of them then select "Combine Sets", it will club the records from both sets