Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Report Question: Can you report on date project status changed to CURRENT and then how long in that status?

Avatar

Level 4

We're looking to get a better handle on projects that have been open too long (started but dragging or incomplete potentially due to resource constraints). Is it possible to build a report that:

  • looks at the date when Project Status was changed to CURRENT
  • then reports on any projects that are still CURRENT four weeks later?

We don't want to use the start date as that clock seems to starts ticking as soon as any modification is made to a task, even if the project isn't set to CURRENT.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

Hi Chris,

Lots of ways to tackle this one.

My favorite would be to use Targeted Auditing to capture the date time that the Project was switched to Current in a custom parameter, calculating a Target Completion Date that is 4 weeks later, then using the latter to filter for Projects whose Target Completion Date is < $$TODAY (but are not yet complete).

If you happen to have the functionality that automatically creates a baseline when a Project is set to Currrent "turned on", another approach would be to run a Baseline report for any Baseline whose Entry Date < $$TODAY-4w (and whose Project is still not complete).

Regards,

Doug