Hey Zhouyi Zhang,
Your solution helps in the case of overall period.
Apologies I was not clear on the explanation.
1. New user - user who has visited for the first time in that particular month
2. Returning - user who has visited in the previous month and in the next month
3. Reactivated - user who has not visited in the previous month but has visited after a month's gap.
Thank you! This helps.
Adding to this solution as a question, is there a way I can get the count(summary) of New, Regular and Reactivated users instead of tagging it to a particular user id?
It will depend on your data, e.g. in your sample, userid 2, there is no data in 01/08/2018, if you only look at userid =2, this row will not be displayed, and then the lookup doesn't work.
Alright. Thank you.