How to count the number of simultaneous conversations for a report?

Question

Asterisk

Good day! I have a clean asterisk without webguys, I also have a BIT.ATS management wants a report on how many simultaneous conversations occur every 5 10 15 30 minutes. Roughly speaking, you need to know the load on kts. BIT.ATS does not know how to report such reports, googling also does not give a special result. Can anyone suggest a thread formula by which you can calculate this statistics. From the initial data, there is the start time of the conversation and its duration. Thanks in advance!

Answer 1

I once did such an analysis. It will take the start time and end time of the conversation.
We make a table (I used LibreOffice), the first column is time, the second is +1 to start a conversation, -1 to end. For ease of analysis, we add time in five-minute intervals and 0 in the second column. Sort by time.
In the third column, we make a cumulative amount for the second column - this will be the number of simultaneous conversations that have been since a given point in time.
Then, according to these data, you can make all sorts of pivot tables.

For example:

Разговор 1: 10:02:17 - 3:10
Разговор 2: 10:03:05 - 1:18
Разговор 3: 10:07:34 - 2:47
Разговор 4: 10:08:19 - 2:05
Записываем таблицу:
10:02:17; +1
10:05:17; -1
10:03:05; +1
10:04:23; -1
10:07:34; +1
10:10:21; -1
10:08:19; +1
10:10:24; -1
10:00:00; 0
10:05:00; 0
10:10:00; 0
10:15:00; 0
Сортируем, считаем промежуточные суммы и длительность интервалов в секундах:
10:00:00; 0; 0; 137
10:02:17; +1; 1; 48
10:03:05; +1; 2; 78
10:04:23; -1; 1; 37
10:05:00; 0; 1; 17
10:05:17; -1; 0; 137
10:07:34; +1; 1; 45
10:08:19; +1; 2; 101
10:10:00; 0; 2; 21
10:10:21; -1; 1; 3
10:10:24; -1; 0; 276
10:15:00; 0; 0; 0
Получаем:
10:00 до 10:05: 1 разговор - 85 секунд, 2 разговора - 78 секунд
10:05 до 10:10: 1 разговор - 62 секунды, 2 разговора - 101 секунда
10:10 до 10:15: 1 разговор - 3 секунды, 2 разговора - 21 секунда