Show all resolved incident tickets open for more than > 7days

[AAN]

Hello, 

Is there anyone familiar with how report ranges work? I am trying to show all resolved incidents that is open for more than 7 days using the incident_sla data view. 

I am using the business elapsed time from incident_sla data view to detect how long the incident has been open. 

See below what I have tried so far but failed, I tested resolving an incident open for 4days but still shows on my report when it should not.

[AndersBGS · Accepted solution]

Hi AAN,

Please see the ServiceNow documentation for report ranges: https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportR...

Please also think about, that if you create the upper limit that you have created, this will both contains incident open for 7 days and incidents open for 4 days. 

If you need some additional guidance, please let me know.

If my answer has helped you in resolving your requirement, please hit the thumb up button and mark as helpful.

Best Regards

Anders

[AAN]

Hello Anders,

Thank you for your response. Do you think it is feasible to only show the incident open for more than 7 days? Hope you could assist. Thank you.

This is the current report I have and I need to add one more range which is the >7days.

Regards,
AAN

[AndersBGS]

Hi Aan,

Yes, off course you can chose to only show incidents which has been open more than 7 days. 

According to your report ranges, I can see that the range is already created.

Hence you just need to add a filter to your report which state as below, to filter incidents out that has been created 0 - 6 days ago.

If my answer has helped you in resolving your requirement, please hit the thumb up button and mark as helpful.

/Anders

[AndersBGS]

Hi @AAN 

if my answer helped your further in you journey, please accept as solution, where the question will be marked as resolved  by that action.

Best regards

Anders