Reporting: Display number of days since state change?

[perkinsarm]

We have developed a custom engineering change workflow. We capture the date when the workflow state changes.

We would like to create reports that display how many days the change has been in the current state instead of the last update date.
Can this be done with the standard reporting tools?

[ghsrikanth]

Hi Bradley,

For your requirement, the metric definition concept will help you for sure, create a metric for State field and that info can be used to construct a report.

Its the regular way of knowing at particular state and whats the duration of being in that state,

This should help you -

Metric Definition Support - ServiceNow Wiki

Mark if it is helpful or correct, feedback is appreciated

[perkinsarm]

This appears to be what we need. Thank you. I may ask more questions as I try to implement this.

[gyedwab]

Heads up while you go to run the report -- the Incident Metric has a Duration field that will tell you how long the incident was in that state, but it only gets populated when Calculation Complete turns to true, which is when the incident stops being in that state.

So for example, in this list view, you can see how long INC0051019 was in a state of "Closed" because that calculation is complete, but most of the other metrics don't have that yet.

So if you want to say "how long has incident XXX been in its current state, you'll need to do an aging report. ServiceNow doesn't support aging reports in its live reporting, but you can use Explore Analytics to generate an aging report:

That'll give you a report like this:

It can be published to the ServiceNow dashboard, live, and drillable for ServiceNow users.

[ghsrikanth]

Thanks for your insights, pretty cool and pretty helfpul