Reporting on Multiple Metrics at once

[jamesmcwhinney]

I am looking for the best way to create a report against multiple metrics at once.

Ideally I would like to generate a report along the lines of the below, listing numerous metrics associated with the approval and fulfillment of a requested item in the service catalog.

Requested Item #	Requested Item Description	Parent Request #	Date Request Approved	Request Approval Duration	Date Item Approved	Item Approval Duration	Date Fulfillment completed	Fulfillment Duration
12345

I know I can create metrics to generate each of the required columns, but I'm not sure how I would go about consolidating them into one report showing all of the metrics for each requested item (as laid out above).

Could anyone offer any insight?

Thanks!

- James

[jamesmcwhinney · Accepted solution]

I think I found it.

Database Views - ServiceNow Wiki