Bernie Galve
New Member
- Joined
- Oct 5, 2024
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
Hello, can I ask for help your help. I find it hard to solve the percentage of Lost Calls by date and language. Please see sample below:
.
below is a sample data, for reference.
.
below is a sample data, for reference.
Wait Time | Name | Status | Call Duration | Language | Class | Date | Offered | |
12/2/2018 00:23:20 | 00:00:41 | LOST | 00:00:00 | English | Economy | 12/02/18 | 1 | |
12/2/2018 07:32:29 | 00:00:03 | COMPLETE | 00:01:58 | Spanish | Business class | 12/02/18 | 1 | |
12/2/2018 07:36:00 | 00:00:07 | COMPLETE | 00:03:29 | English | Business class | 12/02/18 | 1 | |
12/2/2018 07:30:47 | 00:00:01 | COMPLETE | 00:17:32 | English | First class | 12/02/18 | 1 | |
12/2/2018 07:50:36 | 00:00:02 | COMPLETE | 00:02:43 | French | Economy | 12/02/18 | 1 | |
12/2/2018 07:31:56 | 00:00:03 | COMPLETE | 00:24:19 | Russian | Business class | 12/02/18 | 1 | |
12/2/2018 08:04:26 | 00:00:04 | COMPLETE | 00:09:01 | Russian | First class | 12/02/18 | 1 | |
12/2/2018 08:02:45 | 00:00:27 | COMPLETE | 00:22:14 | English | Economy | 12/02/18 | 1 |