Skip to main content

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. 

. 

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

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. 

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:

Link to base

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:

Link to base


Thanks 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!

Thanks 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

Reply


Terms & Conditions