How do I create a "Single Score" report of "Average age of Open Incidents" when State=Open?

[Tony98]

I am trying to create a Single Score report to show:

The Average Duration current Open Incidents have been Open

(Not sure if that's real English!!!)

How do I do this?

thanks

Tony

[Surendra Raika1]

Need a report that shows How much time a specific incident spent in each incident status, and also w...

Similiar discussion .. Metrics is the way ...if you don't want to create something custom

[Tony98]

That would work perfectly. But unfortunately I didn't explain that I created all this on a separate table not relating to the OOB Incidents.

That means something customer - right?

[Adam Stout · Accepted solution]

I would recommend still going the metric route.

Here are docs:   Create a metric

The important note in the docs is this:

Note: In the base system, metrics are configured to work on the task table only. To apply metrics to cmdb_ci tables, duplicate the metric events business rule that currently runs on the task table for the cmdb_ci table. Without the events created, no metric processing can occur.

Once you enable metrics on your custom table, this should be straightforward.