How to pull a report which displays the duration between the Stages in a RITM?

[Renu9]

Hi All, I want to create a report where it has to display the duration for each stage in RITM.

We are having 6 stages , we need to show how much time task is in particular stage. How to calculate it, Please suggest.

Example:Approval stage, development stage , test and uat stage, production stage, etc

The stages are in shown in RITM.

When the stage is in approval stage, an sc_task for approval  will be generated .

Development stage on RITM-> an sc_Task for development will be available. 

Please help me how to proceed with the duration of each stage for RITM.

[Community Alums · Accepted solution]

Hello,

This can be achieved by creating metrics on Requested Item sc_req_item table. Whenever stage changes, it will capture duration. You can create report on metric definition table. 

Kindly note metrics will record data once it created meaning that for past data it's not applicable.

PFB screen shot -

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[Community Alums]

Hey Renu,

Didn't hear back on this.

Is your issue resolved by my answer? If yes, feel free to mark helpful/correct, so it will be helpful for others looking for similar query.

[Renu9]

Yes it worked, but for my requirement , i have created a report on metric instance table