Calculating Timeline of First User Login [.twbx attached]

tableaucommunity@tableau.com — Fri, 20 Sep 2013 20:01:48 GMT

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

date	user-ident	activitycode
13-Aug-13	29246	70
13-Aug-13	30226	70
13-Aug-13	31360	70
13-Aug-14	33250	70
13-Aug-14	36246	70
13-Aug-15	42798	70
13-Aug-16	62342	70
13-Aug-16	74914	70
13-Aug-17	78302	70
13-Aug-17	88592	70

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.

Content in Tableau Community Forums

Calculating Timeline of First User Login [.twbx attached]