10 Replies Latest reply on Mar 25, 2013 7:22 AM by Pulkit Saxena

    Filtering by dynamic subgroups

    John Gonzalez

      Hello all,

       

      I have a series of scatter plots that display data about schools. I'd like to be able to filter data so that when a school is selected, there is choice to view that school and other schools similar to it. I have already calculated the similar schools outside of Tableau and they're stored in a dataset that looks like this:

       

      School    SchoolPeer1 School Peer2 SchoolPeer3 SchoolPeer4 SchoolPeer5

      A1          B1                B2                C3                C4              D3

      B1          B2                A1                C4              D3

      D3          A1              B1                  B2              D4              F5

       

      So what I would need is a dynamic filter that when A1 is selected allows you to filter so that you can see A1 and its similar schools, B1, B2, C3, C4, D3.

       

      Is this possible? Any help would be greatly appreciated.

       

       

      Best,

      John