Pulling (lots Of) Data From One Database To Another

Hi!

How would you solve this in the best way?

I am building a Notion system to handle my freelance business. One goal is to create a Performance KPI database and dashboard from data pulled from my time tracker app.

I have a Time Tracker database where I place all my time tracking data. This is organised into Area, Billable, and Month with data for Project, Task and Hours worked.

I want to pull this data into the KPI database with an entry for each month. I want to be able to sum all Hours worked in Area 1 in January, Area 2 in January, Billable in January, and so on. I see two options for doing this.

• Create a Relation property for each dataset I need and manually choose the relevant pages from the Time Tracker db.
  • PLUS: with the pages in place in the KPI database I can then pull the relevant data with Rollups, and choose Sum.
  • CONS: This is quite time consuming and not that intuitive since the dropdown list for choosing a page for the Relation property does not sort the entries in any way. Yes, I can add shown properties to the list so that I can see which pages I need to choose, but the list is still unsorted and I find myself scrolling up and down to find the right pages.
• Create several views in the Time Tracker for each dataset I need and manually input the needed sums into the KPI database.
  • PLUS: definitely less time consuming than the solution above.
  • CONS: not so elegant (maybe?) and a lot of views to shift through every time I update my KPI database

Any other ideas out there?