7 Replies Latest reply on Jun 22, 2018 9:07 PM by garth.conrad

    Multiselect field values when grouping data

    ChicagoTableauUser

      Hello,

       

      I have a multi select field in my database and there are values I want to disregard when grouping and I won't have all the combinations of data available when I create the tableau view.

      I need to tell tableau to exclude the Dog, Cat, Cheetah values and just show the values in the 2nd column. Since I don't know the order they will show up and I wont have every combination I cant just do groups. Any suggestions?

       

      Thanks!

       

      Field ValueHow I want to show it
      DogNull
      Cat; AppleApple
      Apple; DogApple
      Cheetah; AppleApple
      Pear; CheetahPear
      AppleApple
      BananaBanana