Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jul 19, 2022 12:25 PM
Hello,
I have an airtable dataset that includes:
I want to build a Dashboard Interface where someone could state a “start date” and “end date” and the dashboard would show:
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
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)