2 Replies Latest reply: Mar 7, 2017 12:14 PM by Sunny Talwar RSS

    How to create a Bar Chart that shows calls received by each hour in 24hrs?

    John Blomqvist

      Hello there,

       

      Here is some dummy data:

       

       

      CallIDTime ReceivedTime Ended
      101/03/2017 09:2301/03/2017 09:55
      201/03/2017 09:0101/03/2017 09:21
      302/03/2017 11:2202/03/2017 12:21
      402/03/2017 13:0102/03/2017 13:45
      515/02/2017 13:3015/02/2017 13:33
      621/02/2017 17:1521/02/2017 17:45
      725/02/2017 19:5525/02/2017 20:11
      827/02/2017 21:1127/02/2017 21:32
      904/03/2017 23:3304/03/2017 23:39
      1006/03/2017 08:2206/03/2017 10:32

       

      How can I create a Bar Chart that shows number of calls received per each hour of 24hrs?

       

      In the above dummy data you an see the first two calls were received at 9am, so the bar for 9 dimension value should show 2.

      At 5pm there was only 1 call

      At 9pm it was 1 call

      etc

       

      Any ideas please? I think the challenge is creating 23 dimensions from the date and time value