1 Reply Latest reply on Jun 21, 2012 8:01 PM by Joe Mako

    Find Missing Event Records

    Joseph Lantis

      Hello,

       

      My data is similar to the format below.   Each user should have an event_1 and an Event_4 record for every day from 2012-01-03 to 2012-01-16.  I am trying to classify users into 4 groups: "Complete", "No Event_1", "No_Event_2", "No Event_1 and No Event_2".  I cannot see how to rind the missing records when they don't have either for the date.

       

      Any direction would be helpful.

       

      DateTimeUserID
      Event
      2012-01-0309:5633254Event_1
      2012-01-0408:4645786Event_1
      2012-01-0612:2544855Event_2
      2012-01-0308:0012345Event_1
      2012-01-0312:0012345Event_2
      2012-01-0317:2512345Event_3
      2012-01-1618:2312345Event_4