Scenario
User needs to have a standard Period field in the results of a Saved Time Search. A formula may be used to pull up the Period field which can then be grouped.
Solution
-
Navigate to Lists > Search > Saved Searches > New
- Click Time
-
Search Title: Enter the Name
- Click Results
- Click Columns
- Field:
- Select Formula (Text)
-
Summary Type: Select Group
- Formula: Enter to_char({date}, 'Mon YYYY')
-
- Click Preview or Save & Run