Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with call events. Unfortunately are only the speak duration "linked" with the queue but I'm also interested in measurements like average speak time for each queue.
A call can have none, one, or multiple queue and conversation events. If there is a conversation, is it always the next sequence after the queue (it happens that callers disconnect before the conversation).
I want to be able to calculate that the info queue has 180 sec speak time and the Sale queue has a 120 sec speak time.
A very simplified version of the table looks like this. There are a call_id and call_sequence_nr for each call.
Call_id | Call_sequence_nr | Event | Queue | Duration_sec |
1 | 1 | Menu | ||
1 | 2 | Queue | Info | 20 |
1 | 3 | Conversation | 180 | |
1 | 4 | Queue | Sale | 40 |
1 | 5 | Conversation | 120 |
@Anonymous
is this what you want?
Column =
VAR _sec=maxx(FILTER('Table','Table'[Call_id]=EARLIER('Table'[Call_id])&&'Table'[Call_sequence_nr]=EARLIER('Table'[Call_sequence_nr])+1),'Table'[Duration_sec])
return if('Table'[Queue]<>"",_sec)
Proud to be a Super User!
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |