

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Median call waiting time
Hi
I looking to show the median waiting time for incoming calls to a doctors office.
I am not looking for the average waiting time, but the median. What I have so far doesn't give me the result I am looking for.
I need to see the median waiting time of all calls between the hours 00-06, 07-12 etc.
time(median( aggr( Interval(time(call_answer)-time(call_incoming), 'ss'), Date, doctor_id) ))
Please, I have attached an example file if anybody can help me.
Thank you
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trying to get this?
Expression:
Time(MEDIAN( AGGR(NODISTINCT Interval(time(call_answer)-time(call_incoming), 'ss'), Date, doctor_id, period, row_id)))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trying to get this?
Expression:
Time(MEDIAN( AGGR(NODISTINCT Interval(time(call_answer)-time(call_incoming), 'ss'), Date, doctor_id, period, row_id)))
