What functions can I use to find the average Min time over a date period?

[Tom_S]

Hello,

In order to monitor our front end Phone Effort, we measure the time when a person made the first and last call of the day. For this I am using the Min and Max function and I am able to get the correct values on a particular day.

What function can I use to find the average time of all the first and last calls made over a period of time, let's say in a week. That is: What is the average time the person makes the first call of the day during the week and what is the average time the person makes the last call of the day during a week?

So I am looking for the average min and the average max when the time period evaluated is greater than 1 day.

Any help is greatly appreciated.  

[Vegar · Accepted solution]

Maybe you can solve it using aggr() by date. Like this:

avg(aggr(max(callEnd)-min(callStart),callDate))