Question

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

Additional Context

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

Take Note:

In questions 47, 48, 49, and 50 we’re going to look at New, Churned, Returned, and Retained users. This can be done by setting different time frames (1 month, 1 week, 1 day, whatever you like) that counts the number of active days they have had in that time period, meaning they at least generated one event.

In this query, we’re doing the same thing we did in question 47 which is just counting the number of active days a user has had in a 1 month period, but with time options we’re using an offset that is looking at the previous month. When trying to understand time options offsets, the trailing window is the length of time in which the property will be calculated over, if there is no offset it will default to the most recent 1 month. When you apply an offset you can determine if it will look at that trailing 1 month against 1 month before the current month.

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*