Task Duration Tracking

[AdamVl]

Hello, Workfront Community, Happy Monday! I've been asked if I can put together a particular report that I'm not sure is doable in Workfront, so if anyone is able to provide some guidance, I would be eternally grateful. Essentially, in each of our projects there are multiple review stages, but the actual duration of each review depends on the reviewer (who is not really beholden to the deadline), so we're wanting to build a report that shows how long, on average, the review at each of these particular stages takes, in case we want to remove some of these reviews. I want to be able to see that "we've been at Review #3 for 13 days", or be able to pull a report that shows the how many days between each task's start and end date, or start date and today's date, and then be able to have report that shows "On average, Task #1 takes Y amount of days, Task #2 Takes Z days, etc ." Any thoughts on how to achieve this? Thanks, Adam Vlach Advantage | ForbesBooks

[MariusUz]

Hello Adam, Are you using project templates? One way of doing this would be to create a custom field (drop-down) which contains all Review Stages (#1 - #x). In your project template, you could add this custom field to each Review-Stage-Task, for them to contain an individual value which you can report on. Then I would create a task report, filter for "Review Stage custom field not empty" and group by either Review Stage - which you then could transform to a avg. duration chart - or Project Name. This would work for future tasks, but also already existing tasks if you have the option to bulk-edit them, to assign them the "Review Stage" field&value. Hope this helps! Best, Marius Marius Uzolas HERE

[DagmaraGa]

If you create a task report and filter it by name of tasks you're interested in ( i assume you've got tasks for Review activities), you can create calculated column to count calculation between actual start and finish date of it. displayname=Duration of Task textmode=true valueexpression=WEEKDAYDIFF({actualStartDate},{actualCompletionDate}) valueformat=customNumberAsString Create a blank column in your task report, switch to text mode and copy the code above. Of course, if that's what you need :) Dagmara Garwell BAKKAVOR LTD