10 Replies Latest reply on Oct 24, 2013 6:12 PM by Ville Tyrväinen

    Filter number data based on special character i.e. <10

    David Powell

      Hey there, I'm trying to say that any number which appears in my data as <10 should be treated as the number value 1

       

      i.e. the following data:

      number
      500
      600
      700
      <10
      50
      <10

       

      in tableau should be used as:

      number
      500
      600
      700
      1
      50
      1

       

      how would this be done with a calculated field? i have tried a few different methods and failed miserably