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.