0 Replies Latest reply: Aug 2, 2012 8:54 PM by Mambi Badi RSS

    set analysis count

    Mambi Badi

      Hi, I have a the following structure:

       

      ContactidTargetDATE
      1A2000
      2
      2000
      3B2000
      4C2000
      5A2000
      1
      2000
      6C2000
      2
      2001
      4B2001
      5
      2000
      3
      2000
      4
      2003

       

      I am trying to get this using an expression :

      count the number of Contact IDs for each target, like this :

       

      IF A CONTACT HAS ONE TARGET COUNT ONLY THE 1ST NON EMPTY

      IF A CONTACT HAS MANY TARGETS (ex: CONTACTID => 4) COUNT ONLY THE 1ST NON EMPTY WITH LATEST DATE

      ALSO, I NEED TO COUNT Contact IDs WITH NO TARGET

       

      so the results would be  :


      Targetcount
      A2
      B2
      C1

      1

       

      if i use only count(target) i'm getting this :

       

      Targetcount
      A2
      B2
      C2

      6

       

      I am trying to get this done with Set analysis  but no results :-((:

       

      Thanks;