I am new to SQL and am hoping that someone can help.
I have a table of calls that come into our helpdesk that include the date,
time, talk_time, queue_time and destination. If the destination is 0, then
the call was abandoned before it could be handled by one of our helpdesk
people.
What my manager wants is to group these records by half hour increments such
calls between 12:00:00 AM and 12:29:59 AM would be grouped as 12:00 AM.
12:30:00 AM to 12:59:59 AM would be grouped as 12:30:00 and so on.
Additionally, each grouping would calculate Number Calls Offered, Number of
Calls Handled (Destination <> 0), Calls Abandoned (Destination = 0), Average
Handle Time on Handled Calls (Avg (Talk_Time) Where Destination <> 0)) and
so on.
Half Hour Offered Handled Abandoned Avg Handle
12:00AM 10 8 2 0:04:56
12:30AM 8 8 0 0:03:34
01:00AM 11 9 2 0:05:12
-
-
-
11:30PM 27 24 3 0:06:36
Thank you for taking the time to respond.
Glod Bless America
James
I have a table of calls that come into our helpdesk that include the date,
time, talk_time, queue_time and destination. If the destination is 0, then
the call was abandoned before it could be handled by one of our helpdesk
people.
What my manager wants is to group these records by half hour increments such
calls between 12:00:00 AM and 12:29:59 AM would be grouped as 12:00 AM.
12:30:00 AM to 12:59:59 AM would be grouped as 12:30:00 and so on.
Additionally, each grouping would calculate Number Calls Offered, Number of
Calls Handled (Destination <> 0), Calls Abandoned (Destination = 0), Average
Handle Time on Handled Calls (Avg (Talk_Time) Where Destination <> 0)) and
so on.
Half Hour Offered Handled Abandoned Avg Handle
12:00AM 10 8 2 0:04:56
12:30AM 8 8 0 0:03:34
01:00AM 11 9 2 0:05:12
-
-
-
11:30PM 27 24 3 0:06:36
Thank you for taking the time to respond.
Glod Bless America
James