Report to track the time from when a demand is closed to the creation of a story

[Zenola Smith]

Good Day,

I need assistance with creating a report, which tracks the time from when a demand is closed to the creation of a story.  What are the various ways in which such a report can be created?

Thanks!

[pavani_paluri]

Hi @Zenola Smith ,

If you want to track the time between when a demand is closed and when a story is created, there are a few different ways to set this up in ServiceNow depending on how much automation and visualization you need:
Standard Reporting
- Use the Reports module to build a list or chart report.
- Include the demand’s Closed Date and the story’s Created Date if demand has reference to story .
- Add a calculated field (or script) to show the difference in days/hours.
- This gives you a straightforward report you can share or schedule.

Custom Field + Business Rule
- Add a custom field on the story record (e.g., Time Since Demand Closed).
- Use a business rule so that when a story is created, it looks up the linked demand’s closed date and calculates the difference.
- Makes reporting easier because the value is stored directly on the story.

Key things to decide before building the solution is how demands and stories are linked (reference fields, relationships).

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[Tanushree Maiti]

Hi @Zenola Smith 

You can use the Metric Definition  in ServiceNow to track the time spent on a particular story or scrum task across different states. You can also create reports based on this data for analysis and tracking purposes.

Refer: Measure What Matters: Leverage Metric Instance Tables for Smarter ServiceNow Reports