Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 04, 2024 05:00 PM - edited Sep 04, 2024 05:01 PM
I have the following tables within a base:
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!
Sep 04, 2024 06:58 PM
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
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:
And here's the data:
And you'd use an automation to keep this table updated
Sep 04, 2024 08:14 PM
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?
Sep 05, 2024 02:38 AM
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)