The Results subtab for an advanced or saved search includes a summary type column where you can define how to roll up, or group, data. When you define one or more summary types, a search returns a summary results page, where you can drill down to each group of results.
First you need to define a Group summary type for the field you want to use to group results. The summary results page displays a list of values for this grouped field. You can click a value to drill down each group of results.
For example, in a customer search, you can define a Group summary type for the sales rep field. The summary results page includes a list of all sales reps, and you can click each sales rep to see a list of their customers.
After you have defined a Group, you can define another summary type to provide quantitative results on the summary results page:
Count - Counts the number of results for the field. Counts are usually defined on name or ID fields to get a count of records for each group.
Sum - Sums values for the field.
Minimum - Displays the minimum amount, or the earliest date value.
Maximum - Displays the maximum amount, or the most recent date value.
Average - Calculates the average value for the field.
For example, in a customer search grouped by sales rep, you can define a Count for the customer name field, to display a count of customers for each sales rep. Or, you can define a Sum on the balance field, to display a total balance for each sales rep's customers.
Any field that does not have the same name listed in search criteria field listing (Criteria subtab > Standard subtab) will not be available for drilldown when grouped in Results subtab > Columns subtab.
The results pages where you drill down, by clicking links on the summary results pages, do not include their own subtotals. To add these subtotals on drilldown results pages, check the Show Totals box on the Results subtab. See Showing Totals in Search Results.
There is a special case where you can use a Minimum or Maximum summary type to minimize or maximize the value for a second field, rather than the results field, to return a value for the results field where another field value is minimal or maximal. In this case, this other field should be selected as the When Ordered By Field. See Using When Ordered By Field for Search Results.
To use a saved search as a custom KPI that displays results for multiple date ranges, you must have only one field with a summary type defined. For additional requirements for this type of custom KPI, see Notes on Using Saved Searches as Custom KPIs.
- Search Results Display Options
- Selecting Fields to Display in Search Results
- Entering Custom Labels for Search Results Columns
- Using When Ordered By Field for Search Results
- Showing Totals in Search Results
- Applying Functions to Search Results Columns
- Defining Order and Overall Formatting for Search Results