Unanswered: Query that calculates the number of simultaneous calls
I have a table that has the start date/time, end date/time and duration of a call. I would like to run a query that gives me the number of simultaneous calls in a particular hour. Can anyone help me create this query?
You would need to clarify what you mean by simultaneous calls? Do you mean calls that started within an hour, or that ended in an hour or had some time within an hour counted. For instance, I start a call at 11:59 which goes on until 12:01. Is this 1 call at 11 and 1 call at 12?
Thank you for your response. Good question. I realize there will be overlap with an hourly or daily query. I have a set of call detail records, and from those records, I'm supposed to determine the average concurrent active calls per system, per hour (at a precision of one minute). If I query 7pm to 8pm, I should see the average concurrent calls for the hour (averaging the concurrent calls for each minute) within that hour (for each system).
So, I need a way to check for a count of active calls for 7:00-7:01, 7:01-7:02, etc then average those numbers. A call is considered active if the call's time and duration fall within the current minute being checked.