Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
neapicture
Contributor III
Contributor III

total and the percentage of all calls which were processed within 5 / 10 and 15 minutes

In this excel sheet you see different informations of inbound and outbound calls with a check box if the call center agent has found a final solution..


Now we want to see the total and the percentage of all calls which were processed within 5 / 10 and 15 minutes.

      

datestarttimeendtimeacountIn / Outactionok
05.01.201715:02:4815:12:4960000178outBegrüßungsschreibenx
05.01.201713:03:2713:08:2760000178InUmzugx
10.04.201713:04:0113:06:0260000238InEinzugx
10.04.201713:09:4913:22:4960000240InEinzugx
10.04.201713:13:2313:33:2360000242InStammdatenx
10.04.201713:20:1113:21:1160000242InStammdaten




Can you guys script for me a way out of that?

3 Replies
Sergey_Shuklin
Specialist
Specialist

Hello, Lutz!

Please, find the followin materials. Is this your task? (calls count table)

calls.png

PFA for more information.

neapicture
Contributor III
Contributor III
Author

perfect , thank you