Count Number of Days to Close a Case (e.g. Open, 0-5 Days, 6-49 Days, 50-99 Days, 100+ Days)

To create the search, perform the following steps:

     1. Navigate to Lists > Search > Saved Searches > New.

     2. Select Case.

     3. Provide a Search Title.

     4. In the Results tab > Columns subtab, add the following:

Field	Summary Type	Formula	Summary Label
Assigned To	Group
Internal ID	Count		Internal ID
Date Created	Maximum		Date Created
Date Closed	Maximum		Date Closed
Formula (Numeric)	Sum	Case When {closed} IS NULL THEN 1 ELSE 0 END	0pen
Formula (Numeric)	Sum	Case When {closed}-{createddate} BETWEEN 0 AND 5 THEN 1 ELSE 0 END	0-5 Days
Formula (Numeric)	Sum	Case When {closed}-{createddate} BETWEEN 6 AND 49 THEN 1 ELSE 0 END	6-49 Days
Formula (Numeric)	Sum	Case When {closed}-{createddate} BETWEEN 50 AND 99 THEN 1 ELSE 0 END	50-99 Days
Formula (Numeric)	Sum	Case When {closed}-{createddate} > 100 THEN 1 ELSE 0 END	100+ Days

     5. Click Save and Run.