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.
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:
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:
