Users who logged in last month but not this month ("dropped off users")
Hi all,
I am trying to build a line chart counting users that have "dropped off", i.e. not logged in this (completed) month but logged in the previous month. My data looks like this:
Month
User
Jan-16
A
Jan-16
B
Jan-16
C
Feb-16
A
Feb-16
B
Feb-16
C
Mar-16
A
Mar-16
B
Apr-16
A
Apr-16
B
In this table, User C has "dropped off" beginning March 2016. On a line chart, I would like March to have a value of 1 to highlight this. Is there a way of tracking this on a chart?
