Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Comparing Records

317 3
cancel
Showing results for 
Search instead for 
Did you mean: 
egordin
7 - App Architect
7 - App Architect

I have the following tables within a base:

  1. Projects
  2. Timesheets, with each record linked to a single project and a single task type (single select field)
  3. Estimates, each linked to a single project and a single task type (single select field)

I'd like to be able to compare, ideally in a table and chart (multi series line chart?) in an interface, the amount of hours spent on a particular task type versus the amount estimated for that task type. There may be time spent on a task type that did not have any hours estimated for that task type.

What is the most efficient way to do that?

I could create conditional rollup fields in the Projects table for each task type, but then I'd be on the hook for creating new conditional rollup fields if I ever create new task types. This is the kind of scaling limitation I'd like to avoid, if it is even possible to avoid it. Any ideas?

Thank you!

3 Replies 3

Having a "Task Types" table should do what you want I think.  You'd create a rollup of the Timesheet values and use a lookup for the Estimates value

Screenshot 2024-09-05 at 9.56.27 AM.png

Screenshot 2024-09-05 at 9.56.23 AM.png

Screenshot 2024-09-05 at 9.56.18 AM.png

Link to base

The Chart's trickier though depending on how you want the data shown.  Here's something I put together in the base:

Screenshot 2024-09-05 at 9.57.37 AM.png

And here's the data:

Screenshot 2024-09-05 at 9.58.03 AM.png
And you'd use an automation to keep this table updated

Hi @TheTimeSavingCo! Thank you so much for the quick response.

I think I need to clarify. I'm in need of comparing estimated and actual time spent for each task type for each specific project. Would it be possible to do that?

Yeap, you'd have a table where each record represented a single Project <> Task Type link, and you'd link the Timesheets and Estimates up (via an automation so you don't have to do it yourself)

Screenshot 2024-09-05 at 5.37.18 PM.png

 

Screenshot 2024-09-05 at 5.37.16 PM.png

Screenshot 2024-09-05 at 5.37.09 PM.png