Hey Tobin, could you check this out? You should be able to view the chart’s settings
I’m not too familiar with the chart app but this seems to do what you want!
Idea is we make an “Hour of the day” field with the formula
HOUR([DATE TIME FIELD])
And then we use the chart’s Mean function to just handle the rest
Let me know if this doesn’t work; I’ve always wanted to play with the Chart app more but never had the opportunity, so this is pretty great
Hmm, do you have any records for 6 - 6:59 am and 4 - 4:59 pm?
I got the chart below to show the hours 0 - 24 with just two records in the base, one at 12 am and one at 11:30 pm, so I think it may be due to there not being any records for those hours in your data