Sunday, November 25, 2018

Apply Highlighting on a Saved Search that Uses Function (e.g. % of Total)

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