1. SuiteAnalytics
  2. Dashboards
  3. Key Performance Indicators
  4. Custom KPIs
  5. Selecting an Existing Search to be a Custom KPI

Selecting an Existing Search to be a Custom KPI

To better understand the requirements that your saved search must meet to be used as a custom KPI, see Custom KPIs.

You can edit an existing saved search to be used as a custom KPI by completing the following steps:

To select an existing saved search to be used as a custom KPI:

  1. Choose Reports > Saved Searches > All Saved Searches.

  2. In the Saved Searches list, click Edit next to the search you want to use as a custom KPI. You need to ensure that the search has been defined correctly to display KPI data in the manner you want.

  3. On the Criteria subtab, make sure that no date filters are used as search criteria.

    Note:

    KPIs cannot enforce summary criteria filters because KPI calculations do not include groupings. If a saved search used as a custom KPI includes any summary criteria filters, the result for the KPI may differ from results when the search is run.

  4. On the Results subtab, make sure you have exactly one field that uses a summary type.

    • If you want to display a count of the number of search results for a KPI, select a number or ID field (such as Number) and set a Count summary type for this field.

    • If you want to display summary data such as sum (total), average, minimum, or maximum, select a field and set the appropriate summary type for it.

  5. On the Available Filters subtab, add a date field to be able to compare saved search results over different date ranges in a Key Performance Indicators portlet, a trend graph, a KPI meter, or a KPI scorecard.

    • If the type of search you have selected does not offer a date column as a filter, you may be able to use a different type of search, for example, a transaction search.

    • If you want to use a saved search as a custom KPI in a scorecard and you have enabled the Use Periods option for a scorecard, only saved searches with a Period filter defined as an Available Filter can be defined as custom KPIs for the scorecard.

  6. Edit the search to meet your requirements and resave it.

    • If you do not have the ability to edit and resave this search, you can ask the owner to edit it, or you can create another, similar search yourself.

    • Choose Save & Run to verify the search results are what you expect.

  7. Note the title of the search. It will appear in the custom KPI lists in the Set Up Key Performance Indicators popup and the KPI scorecard.

  8. Now you can use the search as a custom KPI and add it to the Key Performance Indicators portlet, add it to a KPI scorecard, or display it in a trend graph portlet. See Adding a Custom KPI to the Key Performance Indicators Portlet , or Using a Custom KPI in a KPI Scorecard.

For more information about editing saved searches, see Saved Searches.

Related Topics

General Notices