Find the maximum hour per attribute type - starting with 15 minute buckets

[s_mapper319]

Hello!

I have data that describes how road users behave in an intersection collected in 15 minute increments. (Time really means starting time, whereby 06:00 refers to the interval 06:00 - 06:15). I want to find the hour where traffic was highest (maximum hour) for each road user per ID. For example, it might be between 07:15 - 08:15 for light traffic, but 15:45 - 16:45 for heavy traffic. The maximum hour does not need to take the street nor the direction into account, rather should be summed across all those values per road user.

I think I need some combination of rangesum, rangemax, and set analysis, but am struggling to make something work. Any help appreciated! 

Here is an example of dummy data:

[MadiF]

If you're using the data load editor to bring your data in, you could use a group-by clause;

left join (OGTable) Load

ID,

Road User,

max(Time) as Max

Resident OGTable Group by ID, "Road User";