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*
JavaScript errors detected
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.