2 Replies Latest reply on Feb 23, 2016 6:39 AM by Hannah Williams

    Good

    Hannah Williams

      Good Morning

       

      Below is a simplified version of my table, I want to count distinct session_id when status = 0. The answer is 4, but I can't work out the calc.

       

      This is what I am trying:

      COUNTD([cartSessionID])  WHEN  [cartSuccess] = 1 THEN 1 ELSE 0 END

       

       

        

      Session_idStatus
      AB821FB8C7D57BAB12BEDD13013C9BEC1
      AB821FB8C7D57BAB12BEDD13013C9BEC0
      9E0AA46D25A539E043A34385B6421F641
      0AD5B54833A25CCE49423C297ECFD3641
      8447698618CF18E5532750E803FE74A71
      AB821FB8C7D57BAB12BEDD13013C9BEC1
      DF19D0951067F326912CD19C9DF586551
      EE0059DDF1666316F5D95BC6608DEE0D1
      E7DD386FAFC9538E56FAD5862D182C6F1
      91B572887BE3DF8B7ED4E0960B0304E61
      EE5C0634B21FBE8BBCAAB155DAEABE281
      31277A039EE8C574018A75A38B7A258F0
      255C4A9321ADFF4B7635264BB12E76C60
      4D2C80E48FB0694EFC3D66942C712A420
      F26B2401F8498CB06FC3F3501F2D0AE91
      4CF80C1F268EDB2B63D36962277476E81
      AAD7E32983B4E949DC1BA327ABE386F11
      F3DA4E4491AD270B77CC801FFB35374B1
      4D2C80E48FB0694EFC3D66942C712A421
      4D2C80E48FB0694EFC3D66942C712A420

       

       

      Thanks