1 Reply Latest reply on Sep 24, 2018 8:21 AM by meenu choudhary

    Create filter which checks if substring is present

    Marco Gorelli

      I have a field which containing the following values:

      Banana, Mango
      Mango
      Mango, Kiwi
      Banana

       

      I would like to add a filter which can the values 'banana, mango, kiwi', and in each case, only keeps rows where this field contains the selected substring. So, for example, if a user selects 'Mango', the filter should keep all but the last row.

       

      If I just drag the field's name to the `filters` box, I get a filter for each possible value which this field takes (see attached) - this, however, isn't what I'm aiming for.

       

      How can I make such a filter?

       

      I'm running Tableau Desktop 2018.1.