I would like to know averages of the time it has taken staff to complete specific tasks across multiple projects. So for example every project has 2 phases/tasks. I would like to know how long it is taking my staff to complete each task/phase on average across different projects they’ve completed.
For example: staff A has completed 3 projects. Each project has 2 phases/tasks.
For the first phase, they’ve spent 4hours on one project, 5hours on the second, and 3hours on the third.
4+5+3=12. 12/3=4hours. So staff A spends on average 4hours on phase one.
Hi @Generalissimo, The Time Tracking Widget shows the total time spent on items across multiple boards. You can group them by any Column on your boards. You can only track 5 boards though. This would mean that you’d have to add the timer to those boards and have everyone track their time.
What about if you added in a few columns to support it as follows:
Add a ‘completed date’ date column to each board and set up an automation when status changes to X, set completed date to today.
Add a ‘time to complete’ formula column to each board WORKDAYS({completed date}, {Creation log}) or something like that.
Add a ‘phase’ status column to each board
Then create a dashboard and connect all of the boards
add the tile you want eg a graph and you should then be able to adjust what is displayed and grouped. For example here assume schedule is the phase and I’ve averaged the time to complete result from each board
However I would highly appreciate a more intuitive solution (our team is not too tech-savvy). Is it possible to create each project using a similar template, with the template consisting of the two phases?
When staff are working on each phase, I would like each phase to be measured independently of the other. Then I would like an average of how long staff spent on each phase for X amount of projects.