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

[vamshi2]

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

[Ankur Bawiskar]

@vamshi2 

seems it's getting overlapped.

Try to use BETWEEN operator

-> 15-60 Days Ago:

active=true^state!=6^sys_created_onBETWEENjavascript:gs.daysAgoStart(60)@javascript:gs.daysAgoEnd(15)
-> 60-120 Days Ago:

active=true^state!=6^sys_created_onBETWEENjavascript:gs.daysAgoStart(120)@javascript:gs.daysAgoEnd(60)

-> 120+ Days Ago:

active=true^state!=6^sys_created_onONORBEFOREjavascript:gs.daysAgoStart(120)
-> All Active (15+ days):

active=true^state!=6^sys_created_onONORBEFOREjavascript:gs.daysAgoEnd(15)

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

[vamshi2]

Hi @Ankur Bawiskar 

Thanks for your response

but i need different filter conditions 15-60, 60-120 and 120+ days for which "between" operator is not working

[Dr Atul G- LNG]

Hi @vamshi2 

Relative operations may not produce exact results. It's better to use a more precise operation to ensure the output matches the expected result.

[vamshi2]

Hi @Dr Atul G- LNG 

Thanks for your quick response

but i need different filter conditions 15-60, 60-120 and 120+ days for which "between" operator is not working