Group by 'Resolved' giving strange results

[steveturley]

Hi

I'm trying to write a bar graph that groups the 'resolved' value of an incident into 'same day', 2 days' etc.. (I assume these would be calendar days)

Currently I'm using 'Group by' = 'Resolved' but it's showing no incidents as being resolved on 'Same Day' whereas I know have many. I'm convinced I must be doing something stupid. A screenshot of my report is below

Thanks!

[steveturley]

I think I've realised that the horizontal axis means 'same day as today', 2 days from today' rather than 'same day as the incident was opened', '2 days since the incident was opened', etc...

Anyone know how to get to group by calendar days since the incident was opened?

[AndersBGS]

Hi @steveturley ,

You're already grouping by days since the incident was opened. E.g. you graph show same day, 2-5 days, 5-7 days etc. meaning the incident was closed same day as it was opened, it was closed 2-5 days from it was opened or it was closed 5-7 days from it was opened. 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