Forum Discussion
Calculate duration between 2 rows
My data is showing calls, each event during the call is a new row. For example:
| Call id | Queue | Event date | Event | Call transfer |
| 1 | 2020-02-02 10:00:00 | Menu | ||
| 1 | Sale | 2020-02-02 10:02:00 | Placed in queue | |
| 1 | Sale | 2020-02-02 10:03:30 | Conversation | True |
| 1 | Help | 2020-02-02 10:04:00 | Placed in queue | |
| 1 | Help | 2020-02-02 10:05:00 | Conversation | |
| 2 | 2020-02-03 10:00:00 | Menu | ||
| 2 | Help | 2020-02-03 10:05:00 | Placed in queue | |
| 2 | Help | 2020-02-03 10:07:00 | Conversation |
I want to calculate the queue waiting time, both after the menu and after a transfer.
Total queuetime: 1:30 + 1:00 + 2:00 = 4:30 min
Average per call: 2 min 15 sec
I wish I could show but i have been trying but I don't know where to start or if it's even possible to do what I want.
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
Should be able to use a variation of that.
1 Reply
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
Should be able to use a variation of that.