2 Replies Latest reply on Nov 27, 2018 1:45 AM by Spyros Kondylatos

    Filtering all but one rows

    Spyros Kondylatos

      Hello all,

       

      is there any way in Tableau to filter all rows except from one? For example if we have the following table:

       

              

      daythingcase
      1ef
      2rf
      1eg
      1rf
      2eg
      3ee

       

      If I want to use a filter that keeps only the days with value 2 or the days with value 1, but I also want always to keep day 3 in the view. The problem is that that I want to create a calculated field as that:

       

      IF [day] = 1 THEN 'something'

      ELSEIF [day] = 2 THEN 'something else'

       

      but I want day with value 3 to remain in the view for both cases with value 'something' or value 'something else'.

       

      Is there any way to do that?