5 Replies Latest reply on Sep 20, 2013 1:01 PM by Michael Lamont

    Calculating Timeline of First User Login [.twbx attached]

    Michael Lamont

      I am attempting to create a timeline of first time user logins to our system.  The data is structured like this:

       

      dateuser-identactivitycode
      13-Aug-132924670
      13-Aug-133022670
      13-Aug-133136070
      13-Aug-143325070
      13-Aug-143624670
      13-Aug-154279870
      13-Aug-166234270
      13-Aug-167491470
      13-Aug-177830270
      13-Aug-178859270

       

      The goal is a timeline that shows net new user logins per day.  Using Count Distinct of user-ident (unique # for every user) I can see the unique number of users logging in for a certain day, but that means when I do a running sum of CNTD users the total number adds up the sum of each day when what I want is the total unique users for the time whole time period.

       

      The question I'm trying to answer is "how many new user registrations have I had over the last X days/months/years" as well as "on this day we had X new user registrations."

       

      I'm thinking this is accomplished by some combination of a table calculation and/or calculating the first instance of a users recorded activity.  At this point I'm stumped though.

       

      Any help or thoughts would be great. Thank you.  Packaged workbook is attached using cleansed data.