Report on average number of days tickets are open

Requirement: Create a report to see the average number of days tickets are open.

1. Create a calculated column “Days Open” (number type) in Tickets list with formula: =IF(ISERROR(DATEDIF(Created,[Closed Date],”d”)),”0″,DATEDIF(Created,[Closed Date],”d”))

2. Create a report like below using the average function on “Days Open” calculated column

For more sample reports refer https://www.crowcanyon.help/article/239