incident aging report for 15-60, 60-120 and 120+ days
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
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.
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
Have a look : https://www.youtube.com/watch?v=mjA4Qf6nynY
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]
****************************************************************************************************************