Level 3 - Question 49

Question

Build an actor property that counts the number of active days a user has had in the month that is 2 months before the last 1 month

Additional Context

Build an actor property that shows the number of unique days each user has had 2 months ago. Using the show method count unique values of =day_of_month([timestamp]), with a trailing time window of 1 month offset 2 months before. Name the property and save it.

Take Note:

In this question, we’re doing the same thing as we had done in question 48 but we’re just looking 1 month past the previous. Now with these 3 properties, we’re able to count the number of active days (or if a user did or did not have an active day) in the present trailing 1 month, last month, and the month before that.

Solution

Note: The numbers and result do not need to be an exact match as the data changes over time. The query construction is what is most important. See images below.

*Click to enlarge*