Question

Build a query that returns the first action performed by users this week. The result should return a table that lists all users and shows their first event.

Additional Context

Build a query in Explore that uses table view that will return the first value of action filtered to all events starting 7 days ago ending now. Split by userid, Limit 500.

Solution

Note: The numbers and result does 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*