Report to compare actual duration of task against template -

We have a project template that we use for multiple projects (more that 100 currently). I'd like to compare the actual duration of a task compared to our template - we don't use time tracking currently. I'd like to compare the difference from start date to completing to the project template. 

 

Any suggestions? Many thanks

1
9 comments
Spot On Innovative Approach Stellar Advice
Avatar
Anastasia

Hi Danielle! Just to make sure I got that right: tasks in a Project can get pushed back, moved forward, and take longer than planned initially. Your goal is to see when and where those roadblocks were, and how much longer it took to complete a Project than it should have?

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Yes exactly, Anastasia. 

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Anastasia

Danielle, thank you for clarifying! Something I can suggest right now is using Custom Fields to enter additional data, such as "Planned Completion" and "Actual Completion". These fields can then be viewed side by side in Reports. Another option is to use the Baseline Chart in the Analytics section, which compares task’s original scheduled start and end dates to their current scheduled start and end dates.  Would this help?

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

This is really important for me too. In e.g. OmniPlan or MSP it is really easy to compare Planned Start/Finish, Actual S/F and Baseline S/F, so I can see variance between current plan and baseline and between actual start and completion dates and baseline.

If these fields were exported in the Excel export, that would be perfect. The fields should exist internally within Wrike, because the baseline is displayed on the Baseline chart in Analytics.

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi Tom, thanks for your input here. I can see why this would be a useful feature. I think Anastasia's workaround above using Custom Fields will help you, for now, let me know what you think. Thanks for your vote on this suggestion!

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi, where do I find the Custom Fields to enter additional data, such as "Planned Completion" and "Actual Completion" as mentioned above? I have several tasks that have since been delayed in our project, but the Baseline feature shows the Planned Completion and Actual Completion of tasks as being the same. 

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi Kayley, these are regular date Custom Fields. You simply enter the Planned Completion custom field when planning the Projects/tasks. Then enter the date of the Completed date when it actually finished. Then run a Report and choose to show both Custom Fields across all Projects/Tasks so you can see the details side by side.

Hope this makes sense, any questions, I'm happy to help, just post back 👍

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hello all, this would also be useful to us:

Compare this baseline dates to the actual start and finishing dates in reports and in information exports to CSV or in PowerBi (through API, like with custom fields -but not being custom fields, because this custom fields cannot be seen in Gantt Chart).

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

Hi guys, this is currently in the How To forum but it seems to be more like a Product Feedback suggestion, so I've moved it to that forum here on Community.

Please be sure to let us know how (if possible) you are achieving this report right now by sharing your current practice or process. This helps others and our team understand the core outcome needed.

Now, this thread is in the Product Feedback forum, your votes are super important, please be sure to upvote the original post here - and this is why.

Thanks all!

0
Comment actions Permalink

Folllowing List for Post: Report to compare actual duration of task against template -
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post