5 Replies Latest reply on Jun 29, 2018 4:34 AM by Zhouyi Zhang

    Countif/LOD

    Rishabh Kataruka

      Hello Tableau Experts

       

      I am a new Tableau user and need your help with a calculation I need to run. I have attached a sample data set below - I need to return those IDs whose Status is "unsuccessful" and From is "TRUE". While using the countif function, null value is returned because of the way the data is structured.

       

      FromStatusIdType
      TRUE1651mail
      FALSE1490mail
      TRUE1490mail
      FALSE1644mail
      TRUE939mail
      FALSE1035mail
      unsuccessful1651call
      unsuccessful1490call
      unsuccessful1644call
      successful939call
      FALSE1651mail
      FALSE939mail
      completed1651call

                                                                                                                   

       

      Any help will be greatly appreciated. Thanks in advance!