Level 1 - Question 20

Question

Build and Explore query using table view to show which day of the week had the most search actions and purchase actions in the last 7 days.

Additional Context:

This query will require 2 measures and a split by that uses the day_of_week function you used in question 13. Measure 1 should return a count of events filtered to actions that match purchase. Measure 2 should return a count of events filtered to actions that match search. In the split by node enter the = sign to select the day_of_week function and run it against [timestamp] to return each day of the week.

Take Note:

Again we’re using multiple measures to determine which sets of actions are the most common among users on any given day. Notice how multiple measures

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*