Is there a way to report on how long each stage in a workflow took?

[Eric K3]

Management would like to know how long, on average, each stage takes to fulfill a particular request. So, what is the average time is takes to approve the request, average time to procure the item, and then average time to deliver the item.

[sachin_namjoshi]

yes, you can go to workflow context for your workflow to find this.

please navigate to wf_context.LIST on your instance and you will see all activities with start and end date for your workflow.

REgards,

Sachin

[Tracy Davis]

you can report on the sc_report_metric table

the Value field will show you the state and the duration will tell you how long it was in that state.

To calculate averages though you'd need to use PA.

[Eric K3]

I do not see a sc_report_metric table.

[Tracy Davis]

sorry, my typo - it's Catalog Request Metric [sc_request_metric]