Hi @Zoul,
While it is possible to create a report that shows when a Change Request moved from one state to another, calculating the actual duration spent in each state is not natively supported through standard reporting alone.
This functionality is best achieved using Metrics, as they are specifically designed to track how long a record remains in a particular field value (such as a state).
Recommended Approach: Using Metrics:
Navigate to Metrics > Definitions, click New.
Configure the following:
Name: Change State Duration
Table: Change Request [change_request]
Field: State
Type: Field value duration
Once created, you can build a report based on the metric data to view time spent in each state.
Using Reports (Limited Insight):
Ensure sys_history_line Table is in the glide.ui.permitted_tables system property
Navigate to System Properties > All Properties.
Search for the property glide.ui.permitted_tables.
Verify that the sys_history_line table is included in the list of permitted tables. If not, add it to the list.
Navigate to Platform Analytics Administration > Usage and Governance > Reports, click New
Configure the report:
Name: Change Request Lifecycle per State
Source Type: Table
Table: History [sys_history_line]
Set Filters:
Table → is → change_request
Field → is → state
In the Type tab, set Report Type: List
In the Configure tab, set Group By: None
Save and run the report.
This report will give you a view of each state change with timestamps, which you could export and calculate durations manually if needed.
If my response helped, please mark it as the accepted solution so others can benefit as well.
Hi @Zoul,
While it is possible to create a report that shows when a Change Request moved from one state to another, calculating the actual duration spent in each state is not natively supported through standard reporting alone.
This functionality is best achieved using Metrics, as they are specifically designed to track how long a record remains in a particular field value (such as a state).
Recommended Approach: Using Metrics:
Navigate to Metrics > Definitions, click New.
Configure the following:
Name: Change State Duration
Table: Change Request [change_request]
Field: State
Type: Field value duration
Once created, you can build a report based on the metric data to view time spent in each state.
Using Reports (Limited Insight):
Ensure sys_history_line Table is in the glide.ui.permitted_tables system property
Navigate to System Properties > All Properties.
Search for the property glide.ui.permitted_tables.
Verify that the sys_history_line table is included in the list of permitted tables. If not, add it to the list.
Navigate to Platform Analytics Administration > Usage and Governance > Reports, click New
Configure the report:
Name: Change Request Lifecycle per State
Source Type: Table
Table: History [sys_history_line]
Set Filters:
Table → is → change_request
Field → is → state
In the Type tab, set Report Type: List
In the Configure tab, set Group By: None
Save and run the report.
This report will give you a view of each state change with timestamps, which you could export and calculate durations manually if needed.
If my response helped, please mark it as the accepted solution so others can benefit as well.
