- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 19, 2022 12:25 PM
Hello,
I have an airtable dataset that includes:
- Customers: all the information about customers
- Trainings: all the information regarding each training (including the date)
- Inscriptions: that combine Trainings and Customers and also add extra info (e.g. how much the customer payed for the training)
I want to build a Dashboard Interface where someone could state a “start date” and “end date” and the dashboard would show:
- All the trainings in those dates: this seems easy, just used a grid of trainings filtered by those date inputs)
- The total of revenue from those Trainings
In the last bullet, how can I get the SUM of the revenue from all inscriptions in the trainings that are filtered by those dates?
Thanks a lot
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 19, 2022 10:40 PM
Hi Antonio, I’ve set something up here for you to check out
The idea is to add a rollup field to the Classes
table that sums the amount per class. Then, in the interface, we create a Count
element that will sum on that rollup, and connect it to the filter we’ve got set up for the grid
(Not too sure if I set up my base to be the same as yours; let me know if you hit any issues)