question Help with Creating Report in Community Central forum

Help with Creating Report

hollye — Tue, 24 Sep 2024 20:56:18 GMT

How can I create a report in Service now that when ran will tell me if, within a 30 day period, someone has had more that 3 incidents created?

Re: Help with Creating Report

Isaac Vicentini — Tue, 24 Sep 2024 21:55:54 GMT

Hi @hollye!

To create a report in ServiceNow that identifies users with more than 3 incidents created within a 30-day period, you can follow these steps:

1. Create a Report with a "Group by" Field:

Navigate to Reports:
- Go to the filter navigator and type Reports, then click Create New.
Select a Table:
- For the report, select the Incident [incident] table, as you're interested in incidents.
Choose the Type of Report:
- Choose a Bar or Pie chart type, which works well with grouped data, or even a List view if you'd like a detailed breakdown.
Define Conditions:
- In the Conditions section, set the following conditions to filter the incidents:
  - Opened on or Created on is relative Last 30 days (this ensures you're only looking at incidents created in the past 30 days).
Group the Report:
- In the Group By field, select Caller. This will group the incidents by the user who created the incidents.
Add an Aggregation (Count):
- In the Aggregation section, select Count and choose the Number field (or sys_id) to count the total number of incidents per user.
Filter the Results:
- To focus on users with more than 3 incidents, add a having condition in the Group by section:
  - Count greater than 3.

2. Save and Run the Report:

After setting up the filters and aggregations, give the report a name like Users with More Than 3 Incidents in Last 30 Days.
Click Run to execute the report. It will show you a list or chart of users (callers) who have had more than 3 incidents created within the last 30 days.

If my answer helped you in any way, please mark it as correct/helpful 🎯

Regards,

Isaac Vicentini.

Re: Help with Creating Report

hollye — Tue, 24 Sep 2024 22:09:03 GMT

This is perfect, thank you. I guess i'm missing/don't see the aggregation section?

Re: Help with Creating Report

Isaac Vicentini — Tue, 24 Sep 2024 22:57:54 GMT

Check if you selected the report type:

If my answer helped you in any way, please mark it as correct/helpful 🎯

Regards,

Isaac Vicentini.

Re: Help with Creating Report

hollye — Wed, 25 Sep 2024 14:13:53 GMT

It seems as though aggregation is not an option for List type...

Re: Help with Creating Report

hollye — Wed, 25 Sep 2024 14:31:19 GMT

It seems as though aggregation is not an option for List type...I have what is in the attachment, but how do i narrow down to just ones with count over 4, i don't see an option anywhere?

Re: Help with Creating Report

Isaac Vicentini — Wed, 25 Sep 2024 16:48:25 GMT

For the list type is not possible, you must select some type that is compatible like Bar or Pie.

If my response was helpful to you, please mark it as Accepted Solution and/or Helpful. This encourages us to continue contributing to the community.