Problem : What percent of customers from each cohort (year of acquisition) purchased at least 1, 2, 3, N times in 2014?
On the 15th Problem, which I am trying to solve it in a different way, I am stuck at the last step.
If you look at the screenshot, I have the count of the number of purchases each user makes in the year 2014. Also I have them grouped by their year of joining date. However I am not able to count the number of users with joining date in 2011 and number of purchases = 2. Please let me know if you did not get enough clarification. Thank you.
I want something like this:
Year of joining date: 2011
Count(Users who made 3 purchases in 2014) : 10
Count(Users who made 7 purchases in 2014) : 6
Year of joining date: 2012
Count(Users who made 3 purchases in 2014) : 9
Count(Users who made 7 purchases in 2014) : 3
For all the years till 2014
PS: Numbers mentioned above are for example and not derived.