incident aging report for 15-60, 60-120 and 120+ days

vamshi2
Tera Contributor

HI Team, 

i used below filter for  15-60, 60-120 and 120+ days

active=true^state!=6^sys_created_onRELATIVELT@dayofweek@ago@14

 

with above filter count is 6589


and for  15-60

active=true^sys_created_onRELATIVELT@dayofweek@ago@14^state!=6^sys_created_onRELATIVEGT@dayofweek@ago@60
with above filter count is A

active=true^sys_created_onRELATIVELT@dayofweek@ago@59^state!=6^sys_created_onRELATIVEGT@dayofweek@ago@120
with above filter count is B

active=true^sys_created_onRELATIVELT@dayofweek@ago@119^state!=6
with above filter count is C

so A+B+C = 6956 which is not equal to 6589

so i need filter which shows equal count as like total count of individual report

or Please provide me conditions which get data for incidents which are created 15/60/90 days ago








6 REPLIES 6

Hi @vamshi2 

Out of the box (OOTB), these dates are available. You just need to write a script — or simply copy your existing code and convert it into a script.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Dr Atul G- LNG
Tera Patron

Have a look : https://www.youtube.com/watch?v=mjA4Qf6nynY

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************