Level 3 - Question 52

Question

Build an actor property that counts the unique number of active days in the last trailing 1 month.

Additional Context

Build an actor property that counts the unique number of active days users have had in the last 1 month. Using the show method, count unique values of =round_to_day([timestamp]). In time options set a 1 month trailing window. Name the property and save it.

Take Note:

This actor property is doing a very similar thing to the last few questions we worked through. But instead we’re counting the number of active days that a user has had in a given month so we can return a histogram of users based on how many days they have had in a specific month, versus counting binary criteria of whether they were or were no active. Here we’re able to easily see what the average or most common number of days your users are active.

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*