Report the average time of when records are created

[ehgebla]

Hey everyone, not sure if the forum is correct but I need help with reporting.
Our company is still new to ServiceNow.
In reports, I would love to create a report that shows us the average time the incidents/requests are created by the user.
If the peak is between 11 and 12 o' clock I'd love to see a count of how many records were created during this time frame (and of course all other creation times, a list or a bar chart would be preferably).
I already tried a lot with all filtering and/or metrics but it seems I can't get it to work out.

Someone has an idea how to solve this?
Thanks a lot!

Regards

Elena

[Ahmmed Ali · Accepted solution]

Hello @ehgebla 

You can create Time series report to show number of incident created per hour/day/week/day of the week/month etc. below is example to create a report which will show incidents created per hour.

1. Select table as incident

2. Select report type as Line (any of the one in Time series category as below)

3. In configure tab, you can set the trend by created date and per hour as below. you have different option in per field:

Note: you can select the Display data table checkbox to show the data in table format also below the chart.

Then configure your query on incident as if you like to configure for particular assignment group/Creation time like last 3 or 6 months etc and run the report.

Hope it is clear, let me know for any query.

Thank you,

Ali

[nandhini muthu]

Hi Ahmed,

Could you please let me know how to create report for display average time from open to close change requests.

[ehgebla]

Thanks a lot Ali!
I always grouped them by Created, I guess that was my main mistake. Appreciate your fast help!