Help

Help with creating a particular view

Solved
Jump to Solution
272 5
cancel
Showing results for 
Search instead for 
Did you mean: 
LudusLart
4 - Data Explorer
4 - Data Explorer

Hello! I currently am using Make to funnel in data from a webhook and then create a record in airtable. My goal currently is to be able to display Events per hour for each day of the week, I am essentially trying to recreate the table in the screenshot below:

I've been playing with it for the last few days but am struggling with the best way to accomplish this. I believe one of my issues is that the "Date-Time" isn't explicitly coming from the webhook and rather just Airtables "Date" data type with the "Use current Date". Just looking for any guidance/nudges in the right direction on how I could accomplish recreating the table below. 

Screenshot 2024-07-05 at 12.08.48 PM.png

1 Solution

Accepted Solutions

Got it, thanks for the detaisl!  Perhaps try creating a table where each record represents a single hour, and then using a "Count" field per day of the week to output the number of records from that day:

Screenshot 2024-07-09 at 11.40.37 AM.png

Screenshot 2024-07-09 at 11.40.39 AM.png

Link to base

See Solution in Thread

5 Replies 5

Hmm, so you want a log of the number of records created in each hour?  Would the "Created Time" field be useful here?

Yep, precisely. I just want to be able to log the number of records created per hour for each day of the week. I was just stuck trying to aggregate the data and create a similar view to the screenshot in my original post. 

Got it, thanks for the detaisl!  Perhaps try creating a table where each record represents a single hour, and then using a "Count" field per day of the week to output the number of records from that day:

Screenshot 2024-07-09 at 11.40.37 AM.png

Screenshot 2024-07-09 at 11.40.39 AM.png

Link to base

events-table.pngevent-summary.pngThanks for taking the time to provide some insight! I definitely am moving in the right direction with your advice. Is there any way I could have editor access to that "test" base you shared above? I am sort of new to airtable and am not 100% sure on how you established relationships for these tables. I attached some screenshots of my current setup, maybe you'd have some tips!

Yeap, definitely!  Try duplicating the base into your own workspace; that'll give you Creator permissions which will enable you to see the field setups:
https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-airtable-bases