7 Replies Latest reply on Feb 9, 2018 7:42 AM by Olalekan Agboluaje

    Dimension in Multiple Groups

    Nate Valentin

      Good afternoon. I need to be able to create groups and have some of my dimensions be members of multiple groups. And then be able to filter on those groups via a quick filter.

       

      For instance:

       

      My dimension is...

      Person:

      Jim

      Bob

      Nancy

      Sarah

      Tom

      John

       

      My Groups would be structured as follows:

       

      Group 1

      Jim

      Bob

       

      Group 2

      Nancy

      Sarah

      Bob

       

      Group 3

      Jim

      Tom

      John

       

      As you can see, Jim and Bob are in multiple groups. When I try and create the groups in Tableau it seems to want a one to one of dimension to group. I also tried creating sets which worked initially. BUT, I need the ability to filter on the Groups. Ideally a drop down where a user could select one of the three groups (not sure how to do that if I have a Group 1, Group 2 and Group 3 set).

       

      Any ideas would be awesome! Thank you!

       

      Message was edited by: Nate Valentin Here is the packaged workbook. I would love to be able to send through the real data I am working with but I cant. This is a mock up with some data I loaded from a spreadsheet. I added the sets for the Groups though and they are consistent with the post. Thanks for your help.