Case Saved Search that Computes for Support Reps Average Time for ‘Closed’ Cases

1. Navigate to Lists > Search > Saved Searches > New
2. Click Case
3. Enter a Search Title
4. In the Criteria tab, Standard subtab, add the following filters:

Stage is Closed

5. In the Results tab, add the following columns:

Field	Summary Type	Function	Formula
Number
Subject
Company
Contact
Type
Date Created
Date Closed
Assigned To	Group
Formula (Numeric)		Round to Tenths	(ROUND(({closed} - {createddate}) * 24))
Formula (Numeric)	Maximum	Number as Time	AVG(ROUND((({closed} - {createddate} )* 24)))

6. Click Save & Run