Hello,
I hope that someone will help me.
I have a data set as per below:
Date Hour Number Calls
01/01/2014 0 30
02/01/2014 1 23
03/01/2014 2 56
04/01/2014 3 78
05/01/2014 4 90
What will be the best array formula to be use to find the average peak usage time and day for customer's calls?
The data is for the whole year, 365 days, 24 hours but the hours are in the data as 0,1,2,3,4,5,6....23
So I expect the result to be that the average peak usage e.g. 230 calls is 11oclock and the average peak day is Thursday
Many Thanks
Bookmarks