Reporting on Resolved On relative to Opened On

[steveturley]

Hi

I'm trying to report on incidents that have been resolved the same day as they were opened and then group the other incidents by the length of days they've been open (i.e. 2 days, 2-5 days, etc...)

Anyone have an idea how I could create this?

Thanks!

[AndersBGS]

Hi @steveturley ,

Create e.g. a column chart:

Group by resolved:

This will give you this standard range:

If you want to change the interval, you should look at reporting ranges: https://docs.servicenow.com/en-US/bundle/vancouver-now-intelligence/page/use/reporting/concept/c_Rep...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders