Need help to create a report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2025 10:06 PM - edited 11-04-2025 11:07 PM
I was trying to create a report in servicenow linke below
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)
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???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2025 11:27 PM
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-05-2025 12:17 AM - edited 11-05-2025 12:18 AM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-05-2025 12:25 AM
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/