Creating an Aging Report -

[CJPeterson]

Hi All, 

I have a request to create a report while removing the Weekends and pulling ageing report. 

I was able to remove the weekends by using the trend filter, but now just looking into how to pull the ageing of the incidents. I have tried "busniess duration" filter but that is not working. 

Any advice would be great! 

[Sumanth16]

Hi @CJPeterson ,

Please refer to below threads:

https://www.servicenow.com/community/itsm-forum/need-help-to-exclude-weekends-from-the-calculation/m...
https://www.servicenow.com/community/platform-analytics-forum/exclude-weekend-from-quot-incident-age...

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,
Sumanth Meda

[AndersBGS]

Hi @CJPeterson ,

You can create a bar chart report and group by created. This will give you time ranges as below:

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

best regards

Anders 

[samuel_vilko]

Hello @AndersBGS ,

the time ranges for your bar chart are set to ootb, is there a chance to edit that configuration? Let's say I want also to see 2-3 months 4-6 etc.

Thank you, 

Samuel

[AndersBGS]

Hi @samuel_vilko ,

Sure, just go to report ranges and do the necessary configurations: