Create a database comparing multiple entities across time?

[cmm2012]

Hello,

I'm trying to design a database that can accomplish the following:

1. Aggregate data across several different entities (for example, cities).
2. Aggregate data for each entity across different time periods (for example, years).
3. Aggregate data for each entity and time period across multiple metrics (for example, (a) population; (b) property taxes collected; (c) median home value).

I want to be able to use the Interface feature to design a table to review city-level metrics (rows = population, taxes, home value, etc., columns = 2020, 2021, 2022, etc.) with a drop-down chooser for selecting the appropriate city (New York, San Francisco, Chicago, etc.)

Is this possible with Airtable? It's the time series element that I'm having trouble figuring out when constructing my base. Any help much appreciated.

Thanks