5 Replies Latest reply: Jan 23, 2013 11:01 AM by leviwong RSS

    Average Per Day

      Hi Guys,

       

      I need an expression to populate a field in a Straight Table.

       

      The Dashboard is for reporting call volumes in a call centre. I inport the following fields:

       

      SpecialistID (the first name of the person who took the call)

      LoggedDate (the date the call came in)

       

      I currently have a master calendar setup with the following fields:

       

      Day

      Month

      Year

      Quarter

       

      I need to populate a table with the Average number of calls per day based on the current selection in the master calendar.

       

      eg:

       

      SpecialistID     Avg calls per day

       

      JOHN                       10

      JACK                        12

       

      This must be reflective of the current date range selected (so if January is selected, it will calculate average number of calls for each Specialist in January.

       

      Any help would be greatly appreciated.

       

      Regards

       

      L