Hazmat91180
New Member
- Joined
- Apr 25, 2019
- Messages
- 2
Good evening - love this forum!
I am working with the county and trying to figure out how many times multiple departments are communicating at the SAME TIME to our dispatch center. There is this misnomer (which I am trying to prove with data) that the times that different departments queue up dispatch at the same time is very minimal. Attached I have a sample data set of 100 records. I would imagine in this sample set there actually aren't any examples of this. We could just change the data for one of the records to mimic the overlap.
The data set is 6 months worth, 150,187 rows.
The variable that makes this hard is that I really only care about per day. Of course we'll have overlapping times if the date didn't matter, but it only matters during the same day.
Does anyone have an example of this being done with a similar desired result?
https://1drv.ms/x/s!AsmWq8PSnAnJjAHln2T2XoG7a3Wm
I am working with the county and trying to figure out how many times multiple departments are communicating at the SAME TIME to our dispatch center. There is this misnomer (which I am trying to prove with data) that the times that different departments queue up dispatch at the same time is very minimal. Attached I have a sample data set of 100 records. I would imagine in this sample set there actually aren't any examples of this. We could just change the data for one of the records to mimic the overlap.
The data set is 6 months worth, 150,187 rows.
The variable that makes this hard is that I really only care about per day. Of course we'll have overlapping times if the date didn't matter, but it only matters during the same day.
Does anyone have an example of this being done with a similar desired result?
https://1drv.ms/x/s!AsmWq8PSnAnJjAHln2T2XoG7a3Wm