- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 05, 2024 02:44 PM - edited ‎Jul 05, 2024 02:57 PM
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.
.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 08, 2024 08:42 PM
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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 06, 2024 12:38 AM
Hmm, so you want a log of the number of records created in each hour? Would the "Created Time" field be useful here?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 08, 2024 08:54 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 08, 2024 08:42 PM
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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 09, 2024 10:18 AM - edited ‎Jul 09, 2024 10:18 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 09, 2024 07:47 PM
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