Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i´m facing a Problem:
Let´s say i have following Data:
EventDate | SignUpDate | UserId | CountSessions |
---|---|---|---|
01.01.2015 | 01.01.2015 | 1 | 1 |
01.01.2015 | 01.01.2015 | 2 | 1 |
02.01.2015 | 01.01.2015 | 1 | 1 |
03.01.2015 | 01.01.2015 | 2 | 1 |
.... | .... | .... |
with a lot more users and entries in a bigger timerange
what i´m trying to achieve is a cohort analysis, to check for every month if a user has still entries for "CountSessions"
So the Result should be like:
TimeRange | Jan-2015 Count(UserId with "CountSessions") | Feb-2015 Count(UserId with "CountSessions") | Mar-2015 Count(UserId with "CountSessions") | Apr-2015 Count(UserId with "CountSessions") |
---|---|---|---|---|
Jan-2015 SignUp Users | 500 | 450 | 300 | 250 |
Feb-2015 SignUp Users | - | 550 | 450 | 380 |
Mar-2015 SignUp Users | - | - | 350 | 300 |
... | ... | ... | ... | ... |
So I want to have a Chart where i can See for a given Timerange how many Users, who signed up in a given Month (e.g. Jan-2015 = 500) and how many Users of these have still Session Entries in the following Months.
So for this example the Result is: 50% of the Users who signed in Jan-2015 are still active in April-2015 (250 User/500 User).
I hope somebody can help me
Cheers
Steve
HI Sergey can you help me out please..as I m trying cohort analysis from lsat one months..
Thanks in Advanced