Create a Table from the Default Saved Search

Here's how to create a table when you select Default as your saved search. Making this selection makes it possible for you to add the filters in the visualization itself.

  1. Navigate to Configuration > Application Composer.
  2. Click Visualization Configuration in the right-hand pane.
  3. In the Visualization Configurations page, click Add.

  4. From the Create Configuration page, Source Type field, select the Adaptive Search.

  5. Select the object.
  6. Leave the Saved Search field set to Default.

  7. In the Visualization Type field, select Tabular Chart.

  8. In the Columns section, use the Add Column list to add the columns you'd like to display in the table. The table builds as you add columns.

    Columns section
  9. Turn on Actions to display the Actions list (three dot icon) on each record in the table.
  10. Click the column name link to format the columns in the table and to specify the drill down destination:
    1. In the Preferences drawer Format field, add any required format for the column. For example, to add the currency symbol, select Currency.
    2. Click Drill Down to enable drill down from the column.
    3. Select the page you want to open. For example, to open the opportunity details page, select opportunities.

      Preferences
    4. Click Back.
  11. In the Filter field, specify the filters for the table. The field initially displays the filters in the default saved search, but you can update, delete, and add filters.

    Filters section
  12. In the Drill Down section, use the controls to specify which columns you want to display in the list page that opens when users click the View All link at the bottom of the table.

    Initially, the application lists the columns provided by the default saved search.

  13. You can display the Actions menu on each record in the list by switching on Actions.

    Drill Down section

  14. Set the Status field to Active.
  15. Click Create to save the configuration.
  16. Note the number of the visualization configuration on the list page. You'll use the number to include the visualization in the Sales Dashboard.