Reporting Incidents on amount, day and creation time possible?

[AdamUMC]

Hi there,

I would like to report how much Incidents were created after our daily service window (let's say 6:00 p.m. till 7:30 a.m.). I would like to see:
- Amount of Incidents
- Creation time (rounded) of each Incident

It would be nice if the Y- axis could have the hours and the X- axis the days, but then there would be no space for the amount of Incidents. A table grouped on the days and rounded hours would be good enough was well.

I have no Performance Analytics, so I'm wondering if this even is possible?

Thanks!

[Dr Atul G- LNG]

Thanks @AndersBGS 

I was trying in on relative operator. Thanks for adding this in my knowledge. 

[AdamUMC]

Thanks @AndersBGS ! This is a "better than nothing" solution. But how do I get the hours in order on the X- axis like you?

This is what I get:

With a filter like this:

And here with using date, I would like to have the oldest date at left and the newest at right at the X- axis.

[AndersBGS]

Hi @AdamUMC ,

Try to utilize the sort under the filter condition and sort by created A-Z.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AdamUMC]

Thanks! I forgot this option totally. It's a small button, not very visible.

[Rajdeep Ganguly]

Yes, it is possible to create such a report in ServiceNow without Performance Analytics. Here are the steps: 1. Navigate to Reports > Create New. 2. Select the "Table" report type. 3. Select "Incident" as the table. 4. In the "Group by" field, select "Created". 5. In the "Aggregate" field, select "Count". 6. In the "Filter" field, add the conditions to filter incidents created between 6:00 p.m. and 7:30 a.m. 7. Click on "Run" to generate the report. Please note that the "Created" field in ServiceNow stores the date and time in the format "yyyy-mm-dd hh:mm:ss". To round off the creation time to the nearest hour, you might need to create a script or a calculated field that extracts the hour from the "Created" field and rounds it off. Here is a sample script to round off the time to the nearest hour: javascript var gr = new GlideRecord('incident'); gr.query(); while(gr.next()) { var createdDateTime = gr.getValue('sys_created_on'); var createdDate = new GlideDateTime(createdDateTime); var createdHour = createdDate.getByFormat('HH'); var roundedHour = Math.round(createdHour); gr.u_rounded_hour = roundedHour; gr.update(); } This script creates a new field "u_rounded_hour" in the Incident table that stores the rounded hour of incident creation. You can use this field in your report to group incidents by the rounded hour. Please note that this is a basic script and might need to be adjusted according to your specific requirements. Always test scripts in a non-production environment before deploying them in production.