Hello,
Here's what I need assistance with creating
Final Product - Overall roll up of numbers by Supervisor
<tbody>
</tbody>
Data source 1 - List contains Supervisors and there agents
<tbody>
</tbody>
Data Source Two - Contains Agent data
<tbody>
</tbody>
There has to be away for me to link the agents to supervisors and then roll it u as a summary- Data source two comes from a database that is unable to match agents with their supervisors. So I need to create a supervisory report.
Here's what I need assistance with creating
Final Product - Overall roll up of numbers by Supervisor
John | Phone | |
AHT | 80 | 50 |
CSAT | 70 | 75 |
<tbody>
</tbody>
Data source 1 - List contains Supervisors and there agents
Agent | Supervisor |
Tim Jones | John |
Brad Johnson | Sarah |
Sarah Smith | John |
<tbody>
</tbody>
Data Source Two - Contains Agent data
Agent | Phone Aht | Email AHT | Phone CSAT | Email Csat |
Brad Johnson | 80 | 50 | 65 | 70 |
Tim Jones | 70 | 80 | 60 | 55 |
Sarah Smith | 75 | 75 | 75 | 80 |
<tbody>
</tbody>
There has to be away for me to link the agents to supervisors and then roll it u as a summary- Data source two comes from a database that is unable to match agents with their supervisors. So I need to create a supervisory report.