Filtering in Domo External Reports

This article details how to configure filtering in Domo External Reports.

PREREQUISITES:

Established Connectivity to Domo

1. FINDING FILTER NAMES AND VALUES IN DOMO

1.1. For Dashboards

Access the Dashboard

  1. Click the plus icon next to FILTER VIEWS
  2. Choose the desired Filter
  3. Find the Values in the following popup

1.2. For Cards

Access the Card

  1. Click the funnel icon
  2. Click the plus icon
  3. Choose the desired Filter
  4. Find the Values in the following popup

2. Define a Source Object for Data Collection

Start by creating an element. Once you get to the process of Data Collection, define the following:

  1. Choose Data Source that connects Domo and Metric Insights.
  2. Choose Card/Dataset from the pop-up list of available Domo objects that can be a source of data
    • Each item in the list is represented as the path (hierarchy) to the respective object in Domo.
    • If the required item is not displayed, click the Refresh icon at the upper right corner of the pop-up

3. Adding Domo Filters to Metric Insights

Once filters are added for the first time, they are going to be automatically added to all new respective elements with the same Data Source/Report.

NOTE:

  • External filters are tied to Domo objects, not Metric Insights' Elements. This allows Filters to be reused for multiple Elements (without creating new Filters every time an Element is created in Metric Insights).
  • If there are more External Filters or Filter Values that you would like to use for the current Element, you can always set the redundant ones to "ignore".

When creating an Element from Domo, after you define the Card/Dashboard that should serve as a Data Source, you may pre-filter information that is going to be fetched.

Under Manage Filters > [+Filter], you can choose one of the four options for adding filters. Sections below provide information on how to do this.

NOTE: 

  • Examples given below are taken from the Domo Dashboard shown at the top of the page.
  • Domo Filter Name must exactly match filter names from a Domo Card/Dashboard. Filter names are case sensitive. Unless the match is exact, the Filter will not work.

If you have already created Datasets from Domo in Metric Insights, you can choose one for pre-filtering:

  1. Enter Domo Filter Name
  2. Specify if Filter is "Single Value" or "Multiple Value"
  3. Choose the corresponding option for Filter creation
  4. Select Dataset & View
  5. Specify Value Column
  6. [Save]

NOTE: Datasets used here must have Values that exactly match the Filter Values in Domo (if the Values do not match, the Filter will not work).

4. Map to Dimension Values

If you have already used Domo Filters to create Dimensions in Metric Insights, you can quickly choose which Dimension Values you want to use for pre-filtering:

  1. Enter Domo Filter Name
  2. Specify if Filter is "Single Value" or "Multiple Value"
  3. Choose the corresponding option for filter creation
  4. Select Dimension
    • All Dimension Values are going to be loaded to the Values list automatically
  5. [Save]

NOTE: Dimensions used here must have Values that exactly match the Filter Values in Domo (if the Values do not match, the Filter will not work).

5. Enter Manually

  1. Enter Domo Filter Name
  2. Specify if Filter is "Single Value" or "Multiple Value"
  3. Choose the corresponding option for Filter creation and [Save] to display the [+Add Value] button
  4. [+ Add Value] 
  5. Enter the name of the Filter Value
  6. [Save]
  7. [Save]

6. Date

  1. Enter Domo Filter Name
  2. Specify if Filter is "Single Value" or "Multiple Value"
  3. Choose the corresponding option for filter creation
  4. Select Date Format used in Domo
  5. [Save]

7. Setting Defaults for Filters

Configuring defaults allows for defining Filter defaults for Users viewing this External Report. Defaults may be set the same for everyone or applied based on a User Map. Consequently, any number of Users will have the correct Filter Values when they open their External Report.

7.1. Same for Everyone
  1. Click the Pencil icon to assign the Defaults for Filters  
  2. Set [Filter Defaults] to "Yes"
    • You can choose to Pass All Values or select Default Value(s) from the drop-down
  3. [Save]

Repeat to set the desired Defaults for other Filters, if needed

7.2. Based on User Map

Setting the Defaults via a User Map does not restrict Users from viewing non-default Values. It simply sets the Values displayed upon initial viewing. If a User is not in the User Map, the system will initially display the View with no default Values.

  1. Choose a User Map from the drop-down
  2. Match the Filters to this User Map
  3. Proceed with [+Add Mapping] for additional Filters, if needed

8. Deleting Filters

From Manage Filters, click the Trashcan icon next to the filter and confirm your consent.