Report on change

[Aarushi1991]

i need a report which show total time a change was in from new state to review state vs  time it was on Hold 

[Chaitanya ILCR]

Hi @Aarushi1991 ,

you can use OOTB change_request_metric database view for that

update the filter according to your need

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Dr Atul G- LNG]

Hi @Aarushi1991 

Metric is the best way for this and as suggested by @Chaitanya ILCR  OOTB metrics are there.

 and OOTB DB view to get all details

[Robert H]

Hello @Aarushi1991 ,

Please follow these steps:

1) Go to Metrics > Definitions and create a new "Change State Duration" Metric like this:

2) Create another Metric, e.g. "Change On Hold Duration", with the same configuration but for the On hold field.

3) Create at least one new Change Request and move it through the states until it is closed, also set it On hold for a while in between.

4) You can now create reports on the Change Metrics [change_request_metric] view as shown below. In my example I'm using a Multi-Level Pivot report.

Regards,

Robert