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?
Chart visualization
+7
+31Hey 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
+7Hey 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
That works! But any idea why the Hour at the bottom doesn’t start at 6:00am and end at 4:00pm?
+31That 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
+7Hmm, 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
+31Thanks 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.