From Bright Pattern Documentation
< 5.8:Faq
imported>Sergem |
(Updated via BpDeleteTranslateTags script) |
||
| Line 1: | Line 1: | ||
| − | + | = Reporting Database= | |
| − | === '''How do I get the Agent Performance report not to include rejected calls?''' === | + | === '''How do I get the Agent Performance report not to include rejected calls?''' === |
| − | |||
For reporting purposes, Bright Pattern Contact Center can count either all the inbound calls offered to the agent (via ''num_calls_in''), or the answered inbound calls (''num_calls_answered''). | For reporting purposes, Bright Pattern Contact Center can count either all the inbound calls offered to the agent (via ''num_calls_in''), or the answered inbound calls (''num_calls_answered''). | ||
| − | |||
The system also can count rejected inbound calls (''inbound_calls-rejected_calls''). In this case, ''no_answer_calls'' also will be counted as inbound. | The system also can count rejected inbound calls (''inbound_calls-rejected_calls''). In this case, ''no_answer_calls'' also will be counted as inbound. | ||
| − | |||
If you wish to see only the number of inbound calls that were answered, you can query the database for that specific information. In the following example, the database is queried using an application called SQLeo. | If you wish to see only the number of inbound calls that were answered, you can query the database for that specific information. In the following example, the database is queried using an application called SQLeo. | ||
| − | |||
When querying the database for ''agent_performance'', select only the metrics that you want to see. In SQLeo, for example, you do so by following these steps: | When querying the database for ''agent_performance'', select only the metrics that you want to see. In SQLeo, for example, you do so by following these steps: | ||
* Select the table ''agent_performance''. | * Select the table ''agent_performance''. | ||
| − | |||
[[File:Select-agent-performance.png|800px|thumbnail|center|Selecting the desired table]] | [[File:Select-agent-performance.png|800px|thumbnail|center|Selecting the desired table]] | ||
| − | |||
* Right-click the selected table and select '''add to new query'''. | * Right-click the selected table and select '''add to new query'''. | ||
| − | |||
[[File:Add-to-New-Query.png|800px|thumbnail|center|Adding the table to your database query]] | [[File:Add-to-New-Query.png|800px|thumbnail|center|Adding the table to your database query]] | ||
| − | |||
* Select the metrics for ''total_num_calls'', ''num_calls_in'', and ''num_calls_answered'' but NOT ''num_calls_rejected'' or ''num_calls_no_answer''. | * Select the metrics for ''total_num_calls'', ''num_calls_in'', and ''num_calls_answered'' but NOT ''num_calls_rejected'' or ''num_calls_no_answer''. | ||
| − | |||
[[File:Agent-performance-metrics.png|800px|thumbnail|center|Selecting metrics to be shown in the data table]] | [[File:Agent-performance-metrics.png|800px|thumbnail|center|Selecting metrics to be shown in the data table]] | ||
| − | |||
* Click the run [[File:Jaspersoft-Run-Button.png|26px]] button. | * Click the run [[File:Jaspersoft-Run-Button.png|26px]] button. | ||
| − | |||
Your ''agent_performance'' report will no longer show the calls rejected. You can compare the number of calls offered to the agent (''num_calls_in'') to the calls actually answered by the agent (''num_calls_answered'') in order to see how they differ. | Your ''agent_performance'' report will no longer show the calls rejected. You can compare the number of calls offered to the agent (''num_calls_in'') to the calls actually answered by the agent (''num_calls_answered'') in order to see how they differ. | ||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 04:13, 29 May 2024
• 日本語
Reporting Database
How do I get the Agent Performance report not to include rejected calls?
For reporting purposes, Bright Pattern Contact Center can count either all the inbound calls offered to the agent (via num_calls_in), or the answered inbound calls (num_calls_answered).
The system also can count rejected inbound calls (inbound_calls-rejected_calls). In this case, no_answer_calls also will be counted as inbound.
If you wish to see only the number of inbound calls that were answered, you can query the database for that specific information. In the following example, the database is queried using an application called SQLeo.
When querying the database for agent_performance, select only the metrics that you want to see. In SQLeo, for example, you do so by following these steps:
- Select the table agent_performance.
- Right-click the selected table and select add to new query.
- Select the metrics for total_num_calls, num_calls_in, and num_calls_answered but NOT num_calls_rejected or num_calls_no_answer.
- Click the run
button.
Your agent_performance report will no longer show the calls rejected. You can compare the number of calls offered to the agent (num_calls_in) to the calls actually answered by the agent (num_calls_answered) in order to see how they differ.