I have a bunch of property data I am getting each month for multiple properties.
My end goal is to build monthly summaries for each property like this:
- Avg price for each floor plan(1br,2br,studo)
- amount of units available at by floorplan (1br,2br,studio)
Eventually I’d like to put these calculations in some type of chart to compare these metrics at these levels.
Is there a way to run these calculations in Airtable dynamically? Maybe using scripts?
My goal is to create these charts where users can assess these trends.
Any advice would be greatly appreciated!