2 Replies Latest reply on Nov 25, 2018 10:50 PM by Tushar More

    Count difference on the same measure

    Pitchstar Chernenko

      Hello,

      I have the following data

       

            

      case nostatus
      1open
      2close
      3close
      4open
      5pending
      6pending
      7pending
      8open
      9close

       

       

      How do i count per status?

      it would return as follows:

       

      Pending = 3 case

      Open = 3 case

      Close = 3 case
      In excel we have CountIFs to solve this problem. How do we solve this one in tableau?

       

       

      Please advise,

       

      Thanks!