Need help to create a report

Admin7267
Kilo Sage

I was trying to create a report in servicenow linke below 

IMG_20251105_113024.jpg

 

20/10 refers to week : 20th Oct 00:00:00 - 26th Oct 23:59:59

 

1. No of incidents created in that week (79)
2. No if incidents are resolved in that week, irrespective of whenever they are created (74)
3. No if incidents are cancelled in that week, irrespective of whenever they are created (3)
4. No of active incidents at 26th Oct 23:59:59 (61)

 

Admin7267_0-1762326136032.png

Admin7267_1-1762326237072.png

 

I was able to get report for Created/Resolved and Cancelled data using Add Dataset

 

I need trendline for active incidents as well like first screenshot in same report.

How can I achieve like first screenshot???

7 REPLIES 7

Hi @Admin7267 ,

 

When stating you need trendline for active incidents, are you then referring to your backlog according to have many active incidents your have had pr. week or? 

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

@AndersBGS, you're right. I want trend line for how many active incidents are there per week for backlog as well.

 

In report I have used created on last 60 days condition, so need the active incidents accordingly.

Ok, here you can't utilize the normal report builder. It can be created through performance analytics if you have that available in your instance.

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/