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


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?


This discussion has been closed.