Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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

Saba Baig
Tera Contributor

Do you want to achieve all four conditions in one report, or is it different for each?

Admin7267
Kilo Sage

@Saba Baig, I'm looking for all conditions in single report
If not possible, active incidents can be in another report

AndersBGS
Tera Patron
Tera Patron

Hi @Admin7267 ,

 

Please share what you have done so far. According to what you're trying to achieve, then it's for sure possible. 

 

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