For each day over the last 90 days, how many users were active for at least one of the previous 30 days?
Like the query on daily average users, this is a basic query in Interana: measuring user activity over a specific time range. This sort of query is often the starting point for more in-depth explorations of your data.
Building the query
Since you're measuring use activity over time, use a Time view for this query. Then build the sentence for the query. This example is using the wikipedia dataspace (and its
user column), but you would select the column that represents actors in your dataspace.
- Count unique user ID Actors
- To measure how many users were, on any given day, active for the previous month, click the + icon next to the first field to toggle the trailing window option and change it to:
every 1 day trailing 30 days
- This is the default value, but it's useful to know what it is and how to change it.
- All user ID Actors
- (enter a 90-day time range)
Hover over any point to see the count of users who, on any day, were active for the previous month (each data point represents 1 day):
Tip: Samples view
Click Samples to show some of the data used in the query.