I am looking to capture the time between when an request (issue) is entered and when the resolving project is set to Current. I can get issue entry date from the standard fields, but the Current status is being reset whenever our PMs flip a project to Planning to update the timeline. Has anyone found a way to retain the data from the initial Current status?
I'd also love to hear if anyone has a way to easily report on this.
Topics help categorize Community content and increase your ability to discover relevant content.
Nice one Theresa,
It took half a coffee to solve (as it turned out) so I can now offer a way to report on this, but as it is based on my Targeted Auditing Proof Of Concept, I will leave it to you to decide if it qualifies as "easy":
With that tricky but useful bit complete, the "locking" pattern established, and the DATEDIFF calculated expression in hand:
From there, you can then view, group, filter, and CHART on the Request's Request To Current In Days.
Hi Theresa - do you all use baselines? There is a setting where a baseline is automatically created when you change a project to Current the first time.
If you don't really use baselines (meaning you won't have more than one), you could make sure that setting is on and then use this for the "When Resolving Project Was Set To Current"
displayname=When Resolving Project Was Set To Current