Change reports

[LadySGRho89]

Is there a way in to run a report that shows which changes went to a different state during a certain time frame? For example, I want to report on all changes that went from Assess to Authorize during a certain timeframe. 

[SwarnadeepNandy · Accepted solution]

Hello,

You can use the Metric Instance table as the data source and use the Metric Definition field to filter by the Change State Duration metric. This metric tracks the duration of each change state for each change request.

Try the following steps:

• Navigate to Reports > Create New.
• Select the type and format of the report that you want, such as a bar chart, a pie chart, a list, etc.
• In the Data tab, select Metric Instance as the table.
• In the Type field, select Advanced.
• In the Condition field, enter the following condition: Metric Definition is Change State Duration
• In the Group by field, select Value (the value of the change state).
• In the Aggregate field, select Count (the number of changes that went to that state).
• In the Filter field, enter the time frame that you want to report on, such as Created on between 2021-01-01 and 2021-01-31
• Click Run to preview your report.
• You can also customize your report by adding labels, colors, titles, etc. in the Style tab.
• Click Save to save your report.

You have successfully created a report that shows which changes went to a different state during a certain time frame. You can view your report in Reports > View / Run or add it to a dashboard. You can also share your report with other users or groups.

Hope this helps.

Kind Regards,

Swarnadeep Nandy