I've got a call log (datetime, phone#) and have a request to show the day and hour with the most calls.
It's easy enough to get the count of calls per hour (dim Date, dim Hour, exp count(PHONE)) but I'm stumped as to how to show the date, hour of the day with max phone calls, max phone calls.
I can show the dim Date and the aggr(max(aggr(count(PHONE), HOUR, DATE)), DATE) which shows the date and the max calls for the day, but I'm having no luck also returning the Hour as a dimension.