Reporting on Time in Phase

[shillohg]

My team moved into ServiceNow a few months back for Product Development project management. We have Phases for: 

• Initiating (Backlog) 
• Planning
• Executing 
• Delivering 
• Closing

I am trying to figure out how I can run some reports to get average time in phase so we know what our cycle time by project type is but I cannot figure out how to do this. Does anyone know what tables I need to access to be able to do this? 

[JP - Kyndryl]

Hi,

I would created a new Metric definition of type "Field value duration" on your table and Phase field.   So any time the Phase will change, the metric will provide you the time of the former phase value.

See the following metric definitions for examples:   "Incident State Duration",  "Change Type Duration".

The results of your Phase metrics will be in the metric_instance table.   

For good reporting it is preferable to create a database view combining the metric_definition, the metric_instance and your table containing the Phase field.   See an example of such database view with "incident_metric" that is combining metric_definition, metric_instance and the incident tables.

Try a report on the incident_metric database view with Definition = "Incident State Duration";  the Value will contain the different State values and the Duration (mi.duration) will contain the time the Incidents were in each state.