Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Tracking indicator values over time

Topic Labels: Base design
526 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m looking to set up a base to keep track of value of some KPIs across multiple offices/locations over time. I would like to have

  • office level indicators table
  • project level indicators table (with multiple projects per office possible)
  • ability to see at a glance the current (latest entered) values for each indicator
  • ability to see how each indicator per office/project evolved over time

I am currently achieving this by having a month column in the project table, which one record per office-month. The project level table references the calculated office-month field and has one record per project-office-month.

Is there a cleaner, more efficient way of achieving this? Particularly useful would be some way of not requiring to enter all the data each month over again, but only update values that have changed.

0 Replies 0