Create report on incident created between Monday to Saturday

Aswin Chandras1
Tera Contributor

‎03-25-2025 02:12 AM

Hi All,

 

I need a report on incident table that incidents created from Monday to Saturday.

How to achieve this.

Labels:
0 Helpfuls
  • 484 Views
6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-25-2025 02:14 AM - edited ‎03-25-2025 02:26 AM

Hi @Aswin Chandras1 

 

Please try this condition and modify the operator on/after/before  or on after as needed. The trend operator is valid & user here.

 

AGLearnNGrow_0-1742894062681.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Ankur Bawiskar
Tera Patron
Tera Patron

‎03-25-2025 02:23 AM

@Aswin Chandras1 

you can use this to consider Monday and Saturday both the days included

AnkurBawiskar_0-1742894580991.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Aswin Chandras1
Tera Contributor
In response to Ankur Bawiskar

‎03-25-2025 11:00 PM

Hi @Ankur Bawiskar ,

 

I need to see on weekly basis. Like if I see on Monday I just needs to see the tickets created from last Monday to last Saturday. i missed this point.

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Aswin Chandras1

‎03-25-2025 11:08 PM

In that case, the suggestion by @AndersBGS is a good option. You can use the "created last week" operator—give it a try! @Aswin Chandras1 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls