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.
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.
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
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*