10 Replies Latest reply on Jun 15, 2015 8:15 AM by Kenneth Mockler

    Got an interesting one for the Gurus ...  Its the story about a Filter ...

    Kenneth Mockler

      Alright all you Tableau Jedi and Ninjas, been racking my brain on this one for a couple days now and I'm hoping you all will have a way to figure this out.

       

      I'm connecting to a data set that spits out multiple different "treatments" on call volume via a matrix. That part of the data set looks like this (where "T#" is the treatment type):

       

      Matrix CodeTreatment Type
      0000none
      0001T1
      0010T2
      0100T3
      1000T4
      0011T1 + T2
      0110T2 + T3
      1100T3 + T4
      0111T1 + T2 + T3
      1110T2 + T3 + T4
      0101T1 + T3
      1010T2 + T4
      1001T1 + T4
      1101T1 + T3 + T4
      1011T1 + T2 + T4
      1111T1 + T2 + T3 + T4

       

      Here is my conundrum; I need to create a (multi-select) filter that shows each individual treatment. The selection of individual treatments need to reference the matrix code above. BUT, the selection of multiple treatments must represent the INTERSECTION of said selections AND also reference the corresponding matrix codes identified above.

       

      I've added a small section of mock data that resembles my data set. Hopefully I've conveyed my situation correctly.

      If not, let me know and I will try to reword it as best I can.

      By the way, I need to do this in Tableau 8.3.

       

      Thanks in advance gang!

      K