Help with Creating Report

hollye
Tera Contributor

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?

6 REPLIES 6

Isaac Vicentini
Mega Sage
Mega Sage

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:

  1. Navigate to Reports:

    • Go to the filter navigator and type Reports, then click Create New.
  2. Select a Table:

    • For the report, select the Incident [incident] table, as you're interested in incidents.
  3. 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.
  4. 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).
  5. Group the Report:

    • In the Group By field, select Caller. This will group the incidents by the user who created the incidents.
  6. 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.
  7. 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:

  1. After setting up the filters and aggregations, give the report a name like Users with More Than 3 Incidents in Last 30 Days.

  2. 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.

 




Best regards,

Isaac Vicentini
MVP 2025 ✨


If my answer was helpful, mark it as Helpful or Accept as Solution.

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?

hollye
Tera Contributor

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

Check if you selected the report type:

 

IsaacVicentini_0-1727218617548.png


If my answer helped you in any way, please mark it as correct/helpful ðŸŽ¯

Regards,

Isaac Vicentini.

 




Best regards,

Isaac Vicentini
MVP 2025 ✨


If my answer was helpful, mark it as Helpful or Accept as Solution.