How do I get my Histogram to display 24 bins on the X axis (one bin for every hour in the day)?

r_frainier
r_frainier
in Card Building

I have a dataset that includes a Date/Time Stamp showing when a delivery driver has arrived at their destination. I use a Beast Mode calculation on that Date/Time Stamp that strips away the date and displays a value for the hour of the day that the driver arrived at their delivery destination (see Beast Mode calculation below):

 

DATE_FORMAT(`Arrival  Time`,'%H')

 

I want to create a Histogram that counts the number of deliveries based on the hour of the day. My X axis would require 24 bins (one bin for each hour in a day). It looks like the Histogram chart type only allows a maximum of 20 bins. Is there any work around for this?

Comments

This discussion has been closed.

Categories