2 Replies Latest reply: Sep 28, 2017 7:36 AM by Wannes Heirweg RSS

    Average daily traffic

    Wannes Heirweg

      Hello

       

      I have several Excel files in which a 'Time' column has the exact time a phone call begins. (Files are created on a monthly basis)

       

      In the 'Date' column we can find the day a phone call came in.

       

         

      DateDayTime
      01/12/16Thu14:09:20
      02/12/16Fri13:58:09
      13/12/16Tue11:09:15
      13/12/16Tue16:34:35
      15/12/16Thu11:52:11
      19/12/16Mon11:21:04

        

       

       

      I am now looking for a way to indicate the average daily telephone traffic per hour. (over several months, even years)

      Can anyone help me?

       

      Thanks in advance

       

        • Re: Average daily traffic
          Thomas Cullinane

          Load the data without the Time field, instead convert this to an Hour.

          Add a Count(Time)

          and group by the Date and Hour.

          You will then have a count of calls per hour per day

           

          (You could do this in a measure in the app by adding a calculated dimension to create the hour and counting the times, but depending on what you want and how many calls per hour you get it might be better to calculate it in the script)

            • Re: Average daily traffic
              Wannes Heirweg

              Thanks,

               

              I converted the time field into an Hour

               

              This way I was able to create a table with Hour as dimension, with a count Trunk as measurement.

              This gives an picture about the total number of calls received on this date.

               

              But when I use the Trunk average as measurement, the results are all over the place.

               

              (Trunk is a unique key to identify each call)