Search to Count How many Times a Case has been Re-Opened

1. Navigate to List > Search > Saved Searches > New > Select Case.

2. Results tab:

Field	Summary Type	Formula
Number	Group
Subject	Group
Company	Group
Formula (Numeric)	Count	CASE WHEN (TO_CHAR{systemnotes.field} = ('Status')) AND (TO_CHAR{systemnotes.newvalue} = 'Re-Opened') THEN 1 ELSE 0 END

3. Enter Search Title.

4. Click Save & Run.