6 Replies Latest reply on Feb 18, 2016 7:36 AM by pooja.gandhi

    Count of a specif string value

    Hannah Williams

      Morning

       

      This is likely an obvious one, but I'm new to Tableau. I'd like to create a calc based on a specif string, when triptype = oneWay. In sql it would be: count(*) where triptype = 'oneWay'

       

       

      I tried using the IF/THEN function but the result returns 0 - COUNT(IF [triptype] = 'oneWay' THEN [triptype] END)

       

       

       

      Thanks

       

      Hannah