Business Duration Average Report

Jon Collins2
Kilo Sage

Hi Folks, 

I have a stakeholder who would like a report that shows monthly average business duration for sctasks. I am not sure how to set this up. Can someone provide me with some guidance? 

Thanks in advance. 

1 ACCEPTED SOLUTION

BradDavis
Tera Contributor

@Jon Collins,

I believe the below report will get you what you need. If this doesn't quite get you exactly what you are looking for please provide additional parameters or use case. Thanks!

find_real_file.png

View solution in original post

5 REPLIES 5

I'm not sure about this Brad. I'm also looking to create the same report and if you change the Trend By to Closed rather than Created, the trend looks very different. By reporting on tasks created this month, naturally they will have a shorter duration. If you report on tasks closed during this month, they will report the full duration of the life of the ticket, up to closed. This is my logic but have yet to have anyone validate it. What do you think?