5 Replies Latest reply on Dec 12, 2013 10:24 AM by Matt Lutton

    Between calculated field?

    Kiran v

      Does anyone know how to create a calculated field with between, I am stumped. Any help would be appreciated.


      Trying to create a parameter based on this formula and analyze by color. I tried to do this


      if [capacity]> 300 then "Large"

      elseif [Capacity]>= 200 then "Medium"

      elseif [Capacity]>= 100 then "Small"

      else "none"



      what i really want to see is :


      if capacity is between 50-150 then "small"

      elseif capacity is between 151-250 then "medium"

      elseif  250-300+ then "large"

      else "none"



      Can i achieve this in tableau?


      Thanks much