[From Wrike] Project Progress in Wrike Analyze

Project Progress in Wrike Analyze

Hey Community,

This is Herine from Wrike Customer Support once again, your Wrike Analyze wizard 😉

Let's chat about "Project Progress" in Wrike Analyze.

Even though the built-in Project Progress isn’t part of Wrike Analyze, don't worry, we can easily recreate it using formulas. All it takes is understanding which metric your projects are using, then matching it within Wrike Analyze.

Completed tasks

This metric is the most common one and it’s used in the template widget “Project list”:

You can see the formula if you edit the widget and the value “% Task Completion”:

This is simply dividing the total number of completed tasks by the overall count of tasks. Here, the [Task Status Group1]  filter is set to 'Completed'.

The second filter is set to 'Active & Completed', but feel free to leave it out if you'd like to keep deferred and canceled tasks too or move it to the widget filters if it’s relevant for other formulas as well:

Duration of completed tasks

Though this metric might seem a bit more complex, rest assured it becomes simpler once you've mastered the first one. It works by dividing the sum of the duration of the completed tasks by the total duration of all tasks. When it comes to Wrike Analyze, we need to add up task durations as well:

([Total Task Duration (days)],[Task Status Group])/[Total Task Duration (days)]

Just like before, [Task Status Group] is filtered to 'Completed'. You can add a second filter, 'Active & Completed', to omit canceled and deferred tasks from the calculation.

Remember, you could apply this filter directly to the widget level instead of the formula. It’ll keep the formula looking neat for future reference.

Tasks and duration average

The final metric is an exciting mix of the first two: it takes their results, adds them up, and then divides that by two. Let's replicate this in Wrike Analyze:

((COUNT([Task ID]),[Task Status Group]) / COUNT([Task ID]) 
 +
 (([Total Task Duration (days)],[Task Status Group])/[Total Task Duration (days)]))
/2

Again, as in the first two examples, you can add a 'Status Group = Active & Completed' filter either to both the denominator elements or to the widget filters.

And voilà! This wraps it up. I hope these insights will serve your reports well. Happy analyzing! 🙂

Herine Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Herine Wrike Team member Become a Wrike expert with Wrike Discover