May 17, 2022 04:11 PM
I have a table in my base that I use to track “energy level” which is rated 1-10. Each record also has a timestamp on it. I’d like to create a table that charts energy levels on an average day. I’m thinking I need an average energy level for each one-hour increment. Any suggestions?
May 17, 2022 08:54 PM
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
May 18, 2022 07:18 AM
That works! But any idea why the Hour at the bottom doesn’t start at 6:00am and end at 4:00pm?
May 18, 2022 07:42 AM
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
May 18, 2022 09:09 AM
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?
May 18, 2022 04:35 PM
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