User created a saved search (e.g. Event Search) that groups the result by Owner and Counts the Event per owner. The search is also using a Function (% of Total) the gets the percentage of each event per owner. User wants to highlight the result base on a certain percentage (e.g. highlight if percentage is lower than 2%) but is not able to find an option to use under the Highlighting tab:
To resolve this, perform the following steps:
1. Navigate to Lists > Search > Saved Searches.
2. Edit the search.
3. Click the Highlighting tab > Highlight If (Summary) subtab.
4. In the Condition column, set the following:
Summary Type: Count
Field: Formula (Text)
Formula: 100*ratio_to_report(COUNT(DISTINCT {internalid})) over ()
Formula (Text): is less than
Value: 2
5. Select the Background Color (e.g. Red - #ff0000).
6. Click Done.
7. Click Preview or Save & Run.
No comments:
Post a Comment