- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 31, 2023 01:55 PM
I'm trying to calculate return rate (items received/ items delivered), but aggregate them by day. However, there are multiple receiving lines for each event, and only one input for items delivered. I'd normally do a formula based off a pivot table but I'm not sure how to do that in Airtable.
Here's an example of the table I have
Event Name | Items Received | Items Delivered | ||
Timestamp 1 | x | 10 | 40 | |
Timestamp 2 | x | 20 | ||
Timestamp 3 | y | 40 | 50 |
What I need is Line 1 & Line 2 added together for Items Received, and divide that number by line 1 of items delivered.
How do I achieve this?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 01, 2023 05:17 PM
Hey @hrwatkins86 do your event names have consistent and predictable names? I'd imagine you could just create a view that filters by todays date (or date you want to check) and filters based on the event names. Check this out:
Table Setup:
Desired Output in New View - Sums of Items Received And Delivered:
Filter Conditions - note: use the 'add condition group' option at the bottom, to encapsulate both Events with an OR statement (Event 1 or Event 2)
Finally, add a grouping based on date to have Airtable sum the values.
Let me know if that worked for you!!