Beast mode to calculate month over month user count changes
One of the metrics we calculate as a business is our user change month over month. Our main data set we work off of is an activity log dataset which contains the date of the activity, the user id, and details about the activity. For active users we calculate the distinct number of users for that time period such as the month.
However we would also like to look at the changes in users month over month:
resurrected users - users that had no activity last month but are active this month.
returning users - users that were active last month and this month.
new users - users that have had their first activity this month.
Would it be possible to compare these user arrays using beast mode or would we be able to create a table using Magic ETL somehow?