I need to look at dates and a person - and determine the averaged days worked.
I am pulling the data from our data mart using SQL. There's only a date if the person logs onto their phone, so we can count that that.. I know the average working days is 21.1 I think... but if a person took time off, it may be 17 or 18 etc.,,
I need to look at 3 months of data, and return a value that tells me the average days worked - the calculation I need to solve for is below, which is Agent utilization
Agent 1
June 22 days
July 18 days
Avg would be 20
(avg number of calls handled monthly) x ( avg handle time in minutes )
Agent Utilization = -----------------------------------------------------------------------------------------------
(avg number of days worked monthly) x (number of hours worked in day) x (60 Min/hr)
Bookmarks