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(dDATE 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

That works! But any idea why the Hour at the bottom doesn’t start at 6:00am and end at 4:00pm?

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

Thanks Adam,

There is one record between 4-4:59. The odd part is that it starts at 10am. 6am is there but it’s not until after 4pm. I wonder if it has something to do with GMT?

Tobin

Intruiging! I toggled “Use the same timezone” off for my field, and the chart changed to this instead:

Definitely seems like it’s a timezone thing