Skip to main content

Level 2 - Question 26


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.


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.