Creating an Aging Report -

CJPeterson
Tera Expert

‎02-14-2024 09:35 AM

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! 

CJPeterson_0-1707932141910.png

 

0 Helpfuls
  • 1,034 Views
6 REPLIES 6

mia45
Tera Contributor

‎02-20-2025 11:20 AM - edited ‎02-20-2025 11:20 AM

Try using a network days function or an SLA/work hours function in your reporting tool. In Excel, use =NETWORKDAYS(start_date, end_date), and in SQL, subtract weekends using DATEDIFF(day, start_date, end_date) - (DATEDIFF(week, start_date, end_date) * 2). If "Business Duration" isn't working, check if your tool has a business hours calculation setting. Additionally, if you're looking for efficient ways to manage reports, tools like SnapTube PC can help streamline data processing and improve workflow efficiency.

0 Helpfuls

AndersBGS
Tera Patron
Tera Patron
In response to mia45

‎02-20-2025 11:26 AM

Hi @mia45 ,

 

how does your answer provide value according to the request when we talk about ServiceNow?

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

0 Helpfuls