I am trying to plot values / numbers on a bar chart with the x -axis containing the date like 1st July 2019 then as you go along the x-axis, it goes up in 1 hour increments like 8 9 10 11 12 13 14 15 16 17 18 then 2nd July 2019 with the same hours 8 9 10 11 12 13 14 15 16 17 18 etc. Hope that makes sense
So far I have been only able to have one or the other on the x-axis but would be great to know how to have a continuous date and hour on the x-axis.
On the fields for the visual, can you let me know how you got the time on the X-Axis, was there a setting in the fields or format area, just having a blank when it comes to that.
Also my data is in separate columns for date, time and hour [eg 06/08/2019, 08:35:22 AM, 8] and this seems to mess up the graph. I am assuming from your example the date and time needs to be in the one column but in regards to the value how is that collated if you have a value of 1 next to each time stamp,