Level 2 - Question 23

Question

Build a query that will return the minimum timestamp that users purchased. Return the userid and their timestamp.

Additional Context

Build a query in Explore that uses table view that will return the Minimum value of timestamp filtered to action that matches purchase, starting 14 days ago and ending now. Split the query by user.

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*