Level 10

Question

Status Changes on Project

Forum|Forum|9 years ago
May 13, 2016
71 replies
7740 views

I would like to create a report that provides the dates or elapsed days between status changes on a project. For example, days between Current to Pending Approval, Pending Approval to Pending Implementation, Pending Implementation to Closed. We would like to identify where significant delays occur within projects occurred. Suggestions?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Show previous replies

B

BenettaPe

Level 9

Eric, Can I get the report that shows that project changing from one status to another status? I am really trying to capture the date that it changed and what it changed to on that date. Any help will be greatly appreciated.

E

EricLu2

Level 10

Hi:

I’m not sure which Eric you mean, but my name is Eric so I’ll venture some thoughts:

The only way (I know) to know when projects change status is to write a report that searches the Update Log for keywords.

a. Create a Note report;

b. Pick attributes Project Name, Audit Text, Audit Type, Entry Date (sort by this, descending);

c. Filter on the desired project name and where Note>>Audit Type equal Status Change and Combined Entry and where the Note>>Note Objcode is blank;

d. That gives me a report of when the status changed and what date/time it changed.

If you run this for multiple projects, you might want to group the report by project name.

[cid:image001.jpg@01D2BD1B.92F322A0]

Doug_Den_Hoed_AtAppStore

Community Advisor

Hi Benetta. In addition to Eric's note-scouring solution, there is also a Previous Status field that you might want to consider. Regards, Doug

B

BenettaPe

Level 9

Doug, Ok. I'll give that a look as well, I'm trying all solutions provided. Thank you.

B

BenettaPe

Level 9

Eric Lucas, I can not get any data to show. I've tested using project name equals, project name contains, etc ... Nothing shows up on my report. Here is a picture of the filters. What am I missing? Thanks.

B

BenettaPe

Level 9

Adam, The attached file shows the field in the Projects Updates feed that I'm wanting to grab. Any ideas? Thank you.

B

BenettaPe

Level 9

More details, In the issue update feed, i can see when the status was changed on the issue 'and' when the status was changed on the project. In the project update feed, I can see when the status was changed on the project. In my report, it is only pulling the status change from the issue and NOT the status changed on the project - which is what I desire. I have attached my filters also. Thanks for any help on this matter.

N

NRYNRAuthor

Level 10

In a Notes report, set a filter for Note>Audit Type EQUAL Status Change

In the columns, include “Note>Audit Text”

B

BenettaPe

Level 9

Narayan, Made those changes - I get no data - nothing is reported back. This is so frustrating.

N

NRYNRAuthor

Level 10