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

[jblomqvist]

Hello there,

Here is some dummy data:

CallID	Time Received	Time Ended
1	01/03/2017 09:23	01/03/2017 09:55
2	01/03/2017 09:01	01/03/2017 09:21
3	02/03/2017 11:22	02/03/2017 12:21
4	02/03/2017 13:01	02/03/2017 13:45
5	15/02/2017 13:30	15/02/2017 13:33
6	21/02/2017 17:15	21/02/2017 17:45
7	25/02/2017 19:55	25/02/2017 20:11
8	27/02/2017 21:11	27/02/2017 21:32
9	04/03/2017 23:33	04/03/2017 23:39
10	06/03/2017 08:22	06/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

[jpenuliar]

Hi John,

Look at an example given here:

Class function | Qlik Community

Regards,

JP

[sunny_talwar · Accepted solution]

Like this?

[kdaniels-obrien]

Does this solution work if you crossover to the next day? For example, if there are 3 calls at 10AM 12/20/2019 and 2 calls at 10AM 12/21/2019, will the bar graph show a total of 5 calls at hour 10?