Overdue Projects Equation

Hi,

I am trying to build an analytics report that has a gage that shows overdue projects.

The equation I was given by Wrike support does not work, as it is counting all projects in my test space. The equation is:

(COUNT([Project ID]),[Days in Project Due Date],[Project Status Group]),where "Project Status Group" is filtered by "Active"

Does anyone have any advice on how to get this to work?

Thank you!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comentários

This is what I use to count overdue tasks. I'm sure it could be adapted to projects.

sum([Task ID],if(max(DDiff(Now([Days in Task Due Date]),[Days in Task Due Date]))>0,1,0))

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Claire Findlay you are amazing, that works!

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Overdue Projects Equation
[this list is visible for admins and agents only]

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