The method involves transforming the data into a (cat, date, date_type) format, sorting it, and then looping through to calculate concurrent records.
While the current theory walks through the data twice, simplifying to a single pass would be complex due to the nature of concurrent start and end times.
Collection
[
|
...
]