Skip to main content

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

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)

Reply


Terms & Conditions