Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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/3395...
Should be able to use a variation of that.
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/3395...
Should be able to use a variation of that.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |