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.
