Plotting a time series on a bar graph

[Anonymous]

Hi All,

I working with a dataset where Im trying to achieve a hourly breakdown of the number of users that that attend our website. 

The data has timestamped the date and time the user arrives on the website. I have spilt the data and time into separate fields and used the data as a slicer (see image).

I then extracted the hour from the time field and wanted to express it as a bar graph showing the busiest hours of the day. 

However, I am finding this difficult to implement. I want a graph on the x-axis of the hours of the day 00 -23 hours and and the y-axis a count of the number of users. 

Currently, I cant get the time in chronological order. It jusmps for example from 0, 2, 3, 13, 1 ....

Secondly, those hours that have 0 visits isnt shown in the graph. I was thinking of joining a separate hour table but the logic looks complicated on paper.

It looks like a straightforward task and I hope that I am overlooking something. Any suggestions or resources that could help me overcome this would be grateful

[amitchandak · Accepted solution]

@Anonymous , I think this data is sorted Ascending on Measure/value. Check the option in three dots and correct it

Or  create an hour field like this and use on axis

hour = hour([datetime])