Prepare a performance report for a Activation call center.
1. Orders will be falling throughout the day.
2. Agents will be working from 7 am till 9 pm.
3. As a result of their work the orders will be either:
3a. The order will disappear from the End of the day list/any of the Mid day list.(successful). OR
3b. The order will be moved to another Task name. (Successfully resolved in one task but moved to another task). This will be counted as cleared under initial task & also counted as Received under new task. OR
3c. The orders will remain in same Task but moved to Order sub status (Column E) = HELD (Unsuccessful & will be resolved later).This will be counted as cleared under initial task & also counted as Received under new task(Acknowledged HELD Orders Table). OR
3d. The order will remain under same task. Agent did not complete tasks work. This will still appear under same end of the day list. Count against End of the day numbers.
4. Extracts of tasks will be taken throughout the day & resolved through out the day.
5. Tables in the first page indicates the key working group statistics.
6. Sheets indicates the data samples (Morning extract , Mid Day extracts, End of the day extract)
This is urgent & need the results asap.