Level 2 - Question 26

Question

Which day of the month (1-31) in the last 2 months has the highest count of events? Return a chart that shows the days of the month and the count of events for those days.

Additional Context

Build a query in Explore that uses table view that will return a count of events filtered to all events, starting 2 months ago and ending now. Split by =DAY_OF_MONTH([timestamp]).

Take Note:

The day_of_month function can help you discover which days most events are generated on. This is very helpful for trending, determining release dates, high traffic days, or days when you might run into latency issues.

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*