Level 2 - Question 25

Question

Build a query that returns which day of the week in the last 7 days has the most events. Return the string value day of the week (M-F).

Additional Context

Build a query in Explore that uses bar view that will return a count of events filtered to all events, starting 7 days ago and ending now. Split by =DAY_OF_WEEK([timestamp]).

Take Note:

Functions can be very helpful in formatting or aggregating less user friendly timestamps into easily digestible days, months or timeframes.

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*