Median call waiting time

qw_johan — Sat, 25 Jul 2015 20:13:05 GMT

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

Re: Median call waiting time

sunny_talwar — Sat, 25 Jul 2015 23:37:40 GMT

Trying to get this?

Expression:

Time(MEDIAN( AGGR(NODISTINCT Interval(time(call_answer)-time(call_incoming), 'ss'), Date, doctor_id, period, row_id)))