3 Replies Latest reply: Dec 1, 2017 3:34 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)