4 Replies Latest reply: Jun 2, 2014 1:47 PM by Lennart Billekens RSS

    Creating an average timeline based on datetime

      Hi,

       

      I have a dataset from a callcenter with all inbound calls in 2013 (phonenumber, number called, time called, call duration, wait time, call forwarding etc).

       

      I have a datetime field which shows the date and time the call was received (eg 2-1-2013 7:38:07). Now I want to create a timeline chart that shows a line displaying the average number of calls on a time (starting at 07:00 and ending at 19:00).

       

      What is the easies way to do this? I've already started creating a master calendar.

       

      Thanks in advance,