From af raw excel datafile i need to get some reporting done.
The data file is 5000- 10000 lines and contains call data in 15 coloumns.
I need to have the report in excel with graphs for every month. The job must be done every week.
I need the following data:
Avg. Waiting time
Lost calls (number)
Number of calls total
Number of calls per weekday (monday, tuesday etc.)
Avg. talk time per agent
Number of calls from Denmark
Number of calls from Sweden
Number of calls to 98249820
Calls to all other numbers should be sortet out of the statistic.
The report must be in Google Spreadsheet.