Top N caller by date

[Anonymous]

I need some help for (what it looks like) a simple waiting time calculation.

Example table:

So I want to calculate the caller with the longest waiting time.

Result should be like:

Any help would be appreciated.

[Anonymous]

Time	Duration	Caller	Call ID	Index
13:41	00:00	1234	e518bca3a1ad	1
13:42	00:00	1234	e518bca3a1ad	2
13:43	00:00	1234	e518bca3a1ad	3
13:43	00:00	5678	e8c03f3cfe2a	1
13:44	00:00	1234	e518bca3a1ad	4
13:44	00:00	5678	e8c03f3cfe2a	2
13:45	00:00	1234	e518bca3a1ad	5
13:45	01:46	5678	e8c03f3cfe2a	3
13:45	00:00	1234	e518bca3a1ad	6
13:46	00:00	1234	e518bca3a1ad	7
13:47	00:00	1234	e518bca3a1ad	8
13:48	00:00	1234	e518bca3a1ad	9
14:03	00:00	9876	9be71da773a2	1
14:04	00:00	9876	9be71da773a2	2
14:04	00:00	1234	3cefb8f84ddf	1
14:05	00:00	9876	9be71da773a2	3
14:05	00:00	1234	3cefb8f84ddf	2
14:06	03:32	9876	9be71da773a2	4
14:06	00:00	1234	3cefb8f84ddf	3
14:07	00:00	1234	3cefb8f84ddf	4

Result should be:

Caller	Total duration without being answered
1234	00:10

[CNENFRNL]

You should use an unique id for each start/end pair

[VahidDM]

Hi @Anonymous 

Can you share a sample of your data in the table format to be able to copy and past that (Not Image 🙂 )

Appreciate your Kudos!!