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

[neapicture]

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.

date	starttime	endtime	acount	In / Out	action	ok
05.01.2017	15:02:48	15:12:49	60000178	out	Begrüßungsschreiben	x
05.01.2017	13:03:27	13:08:27	60000178	In	Umzug	x
10.04.2017	13:04:01	13:06:02	60000238	In	Einzug	x
10.04.2017	13:09:49	13:22:49	60000240	In	Einzug	x
10.04.2017	13:13:23	13:33:23	60000242	In	Stammdaten	x
10.04.2017	13:20:11	13:21:11	60000242	In	Stammdaten

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

[Sergey_Shuklin]

Hello, Lutz!

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

PFA for more information.

[neapicture]

perfect , thank you

[MarcoWedel]

Qlik Community Tip: Marking Replies as Correct or Helpful

regards

Marco