Open Items Report - Calculating How Long Ticket has been Opened.
Content
Hello
I have a report that I use for different teams that show a list of open items with two main columns: "Response Time," so how long it took to respond to a new incident and "Days Open" which shows how long the ticket has been opened. Unfortunately this takes into account weeks and what I'm looking for is getting only the business days; so calculating the time the ticket has been open excluding weekends and holidays. I'm having a hard time using the rel_date_diff function and trying to get what I need from the inc_performance
Tagged:
0