X Axis Interval - hourly
Context: This graph aims to show the number of tickets sold for our business at each hour of the current day. The data updates every 10 minutes. There is data associated with every minute of the day.
Problem: During the first couple of hours of the day, even though I have the "Card Date Range" set to
"Today" and "Graph by" set to "Hour", the graph lumps all tickets into the hour, but there is an interval of 5 minutes between each hour (the intervals then become 1 hour as more data flows in and we have a 8am, 9am, 10am, and 11am for example).
Question: How do I make the axis only show intervals of 1 hour, even if there are only 2-3 hours available that day? OR how do I make the graph ALWAYS show 6am - 10pm even if there is no data in the later hours just yet?
I've tried toying around with X axis interval but can't seem to get it to understand the "1 hour interval".
Please let me know!
Thanks so much,