1 Reply Latest reply on May 17, 2013 9:16 AM by Alex Kerin

    Trying to get an Average of Daily Maximums

    Chris Stewart

      Hello all!

      I'm running into trouble coming up with a view of a particular data point and wanted to toss it out to see if anyone has solved this already.

       

      I have data in the form of call records for my call center.  It includes the amount of time each call waited before it was answered.  We track and chart on a daily bases both our average speed of answer and the longer hold time any single caller waited before being answer.  All easy and beautiful so far. 

       

      Now for the sticky part.  I want to take the maximum hold time from each day and average it over the quarter to produce a single number.  Any suggestions on how this might be done?