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!
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))
Claire Findlay you are amazing, that works!