Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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";