Median call waiting time

[qw_johan]

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

[sunny_talwar · Accepted solution]

Trying to get this?

Expression:

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