Skip to main content
waffle.svg
Domo Knowledge Base

Applying Page-Level Filters

Intro

You can use Page Filters to apply data filters that affect all of the KPI, Sumo, and Domo App cards powered by a specified DataSet in a page. All of such cards with applied filters are marked with a  icon. In this way you can quickly spot all cards in the page in which you have applied filters. For example, you could set a filter for all cards powered by a specified DataSet to show values falling under a specified threshold. All cards powered by that DataSet would then be filtered to show only the specified information.

If PDP (Personalized Data Permissions) is enabled for the selected DataSet, your filter options are limited to what is available to you based on your policy. For example, if you are a member of a policy that can view content only for western states, you can filter only on content that is available to you. Likewise, if you have access to all rows in a policy, you can choose whether to filter on all data or select specific policies. For more information about PDP, see Personalized Data Permissions (PDP).

The Page Filters applied to a page are

  • somewhat personal customizations. When a Page Filter is saved, the values selected affect your view only and others do not see the page filter values you add.  However, others do see the DataSets and columns of the Page Filter added. 

  • "sticky" customizations that remain until you remove them.

  • inherited by a card using the filtered DataSet when viewing or drilling to the card in the Details view.

  • not applied to a card when viewing the card directly, either through a link or a search.

You can apply or edit card filters in the Details view of a card. For information about applying filters to KPI cards, see Adding Filters to Your Chart.

When adding date filters, you can choose to apply filters to a range of dates or to individual time units (which may be days, weeks, months, etc., based on the date grain of the data).

Important: When adding subsequent cards to a page (that is, all cards after the first), you must use the Existing Data option and select your original DataSet. If you re-add the same DataSet using the Excel or Google options, filtering does not work.

Note: If you have a "Participant" default security role, you cannot add or remove Filters, but you can edit existing Filter data. For example, if a user had added a Filter named "Customer," you could not remove that Filter, but you could change the customers selected in the Filter. If you have an "Admin," "Privileged," or "Editor" default security role, you can add and remove Filters as well as edit Filter data. You can also do this if you have a custom role with "Edit Pages" enabled. For more information about default security roles, see Default Security Role Reference. For more information about custom roles, see Managing Roles.

Training Video - Adding Page Filters

Learn about adding Filters to a page that affect all KPI cards powered by a specific DataSet in that page. 

 

Notes: The product training videos are for Domo customers and clients only.

Applying Page Filters

Use the following instructions to apply Page Filters to cards on a page.

To apply Page Filters,

  1. Navigate to the page in Domo that you want to filter.

  2. Click , which is located in the upper right corner of the page, next to the collaborator profile pictures.

  3. Select Turn on Page Filters. (If the page does not contain any cards, this option is not available. Also, some system pages, such as the Shared page, do not include this option.)

    A bar appears with Reset FiltersAdd Filter, and Save Filters buttons. If PDP policies are enabled on DataSets used in any cards in the page, and you have access to all the rows, a button reading All Rows appears. 

  4. (Conditional) If you want to filter on all rows in PDP-enabled DataSets used in the page, leave the PDP options set to All Rows. If you want to filter on a specific policy, do the following:

    1. Click the dropdown arrow next to All Rows.

    2. Click Select Policies.

    3. Check the boxes for all policies you want to filter on. 

    4. Click Apply.



      For more information about PDP, see Personalized Data Permissions (PDP).

  5. Click Add Filter.

    A list of all column names used in DataSets in cards in this page appears. If a column name is used in more than one DataSet, an arrow appears to the right of the name so you can filter down to the desired DataSet if you want. 

  6. Click the name of the column you want to filter.

    Alternatively, if the column name is used in more than one DataSet and you want to filter to show just the rows in a specific DataSet, you can click the arrow next to the column name to bring up a dialog with the names of all the applicable DataSets. Here you can check the boxes for all the DataSets you want to show rows for (or simply select all DataSets by checking the Select all box). 

    If you select a column that appears in more than one DataSet without filtering down to a specific DataSet, the columns from the DataSet powering the most cards in the page will be used for the filter.   

    After you select a column or DataSets, a filter button appears on the left side of the gray bar, and a dialog appears in which you can select your filters. The interface components of the dialog differ depending on whether the column or row you selected contains series, amount, or date data.
  7. Do one of the following:

    • (Conditional) If the selected column contains string data,

      series_data_filter_dialog_new.png

      1. Select the checkboxes for each series you want to show in the cards in this page.
        You can select all of the checkboxes by clicking All or deselect all of the checkboxes by clicking None.
        You can filter the series that appear in the list by entering a keyword or a string of characters found in a keyword in the Filter by field.
        Finally, if columns are included from multiple DataSets, you can narrow down the represented DataSets by clicking page_filters_filter_datasets.png then choosing the desired DataSet.  

      2. Specify whether the items you have checked appear or do not appear in your chart by selecting In or Not In from the menu in the top right.

      3. Click Apply.

    • (Conditional) If the selected column contains amount data,

      amount_data_filter_dialog_new.png

      1. Do one of the following:

        • If you want to filter amounts based on a range... 

          1. Leave the dropdown menu in the upper right corner set to Range.

          2. Select a condition statement from the menu.
            One or more fields may appear, depending on the condition statement.

          3. (Conditional) If one or more fields appeared when you selected a condition statement, enter the desired amounts in the fields.
            For example, if you wanted your cards to show information for amounts between 200,000 and 300,000, you would select is between from the menu, enter "200,000" in the first field, and enter "300,000" in the second field.

        • If you want to filter amounts based on specific values from your DataSet...

          1. Select Selection in the dropdown menu in the upper right corner.

          2. Check the boxes for all of the values you want to filter on. 

            You can select all of the checkboxes by clicking All or deselect all of the checkboxes by clicking None. Or you can filter the values that appear in the list by entering a string of numbers in the Filter by field. If columns are included from multiple DataSets, you can narrow down the represented DataSets by clicking page_filters_filter_datasets.png then choosing the desired DataSet. Finally, you can specify whether the items you have checked appear or do not appear in your chart by selecting In or Not In from the menu in the top right.

      2. Click Apply.

    • (Conditional) If the selected column contains date data,

      date_data_filter_dialog_new.png

      1. Do one of the following:

        • If you want to filter dates based on a range... 

          1. Leave the dropdown menu in the upper right corner set to Range.

          2. Select a condition statement from the menu.
            One or more fields may appear, depending on the condition statement.

          3. Enter the desired dates in the fields as necessary.

            For example, if you wanted your cards to show information for dates between 1-31-2014 and 4-30-2015, you would select is between from the menu, select January 1, 2014 in the first field, and select April 30, 2015 in the second field.

        • If you want to filter dates based on specific dates from your DataSet...

          1. Select Selection in the dropdown menu in the upper right corner.

          2. Check the boxes for all of the dates you want to filter on. 

            You can select all of the checkboxes by clicking All or deselect all of the checkboxes by clicking None. Or you can filter the dates that appear in the list by entering a filter string in the Filter by field. (For example, if you wanted to filter down to dates from 2010, you would enter "2010" into this field.) If columns are included from multiple DataSets, you can narrow down the represented DataSets by clicking page_filters_filter_datasets.png then choosing the desired DataSet. Finally, you can specify whether the dates you have checked appear or do not appear in your chart by selecting In or Not In from the menu in the top right.

      2. Click Apply.

The affected cards in the page update to reflect the Filters you have selected. In addition, a Filter icon appears on each affected card.

To edit a Filter,

  1. Click the button for the Filter in the gray bar at the top of the page.
    The dialog for the Filter appears.

  2. Edit the Filter settings as desired.

  3. Click Apply.

Your changes are applied to the Filter.

To remove a Filter,

  1. Click the button for the Filter in the gray bar at the top of the page.

  2. The dialog for the Filter appears.

  3. Click .

  4. Click Continue to confirm the removal.

This Filter is removed, and all of the cards that used the Filter are updated accordingly.

To hide Page Filters,

  1. Click , which is located in the upper right corner of the page, next to the collaborator profile pictures.

  2. Select Turn Off Page Filters.

Your Page Filters are hidden and all of the affected cards are updated. Hiding Filters in this way does not deactivate them completely. If you want to deactivate Ffilters, you must remove them using the steps above.

You can reapply your hidden Filters by selecting Turn On Page Filters in the page Options menu.

Note: Turning off Page Filters does not remove the Filter for all users. The only way to make a Filter on a card apply to all users is to apply a Filter while editing a card. Consequently, you cannot persist a page Filter to multiple cards for all users.

Applying Card-to-Card Filters

When you apply Card-to-Card Filters in a page, you can mouse over a specific chart element in a card, and that same element will be highlighted in all other cards in the page that share it. This allows you to make quick correlations between your cards that might otherwise take hours. 

For example, let's say user Tanya is a manager in her company's retail department. She has access to a Domo page called "Retail" that includes a number of cards related to profits and spending for her company, as shown here:

interaction_filters_before.png    

All of these cards show disparate but related data for roughly the same time period—early 2013 to early 2015—with a monthly date grain. As it is now, Tanya can go into each card one at a time and see data for a given month. This is useful, but what Tanya really wants to do is compare data for all of the different cards across the same month. Specifically, she wants to correlate the data for "RT: Gross Profit and Margin," "RT: Gross Margin by Product Line," and "RT: Cost per Conversion" for January 2014. Before Card-to-Card Filters, she probably would have had to look at each card one at a time, write down the values for January 2014, and finally compare them. But now, all she has to do is mouse over the bar for January 2014 in any of the cards, and the same bar highlights in all of the others:

interaction_filters_after.png

Tip: Card-to-Card Filters work best when the card size is set to "Large" or "Full." For more information about card sizing, see Changing the Size of Cards in a Page.

With Card-to-Card Filters, you can also click on a chart element to apply a filter for that element to all cards in the page. For example, if you clicked on the bar for "2014-Jan," all cards would be filtered to that month. This also works for rows in tables. You can turn off this filter by clicking the element again. 

Card-to-Card Filters are automatically enabled in Storytelling Dashboards. In standard pages, you can toggle them on or off. When you turn on page filters in a standard page by selecting  > Turn on Page Filters, an Interaction Filters toggle appears and is turned on by default. You can disable or reenable Card-to-Card Filters by clicking this toggle. If you turn off page filters, Card-to-Card Filters are turned off as well.

As with page filters, Card-to-Card Filters are personal customizations. Others do not see page filters you add (unless you are the page owner, in which case everyone who visits the page sees the filters and cannot change them).

Using Filter Cards to Filter Card Content 

You can use Slicer, Checkbox, Radio Button, Range, and Date Selector cards to apply filters to all of the cards on a page. You build these cards in Analyzer just like any other chart types.

Filter cards only work when Card-to-Card Filters are turned on (see the preceding section for more information). If Card-to-Card Filters are not turned on, clicking a filter opens the Details view for the card instead of applying the filter.

Slicer, Checkbox, and Radio Button Cards

Slicer, Checkbox, and Radio Button cards contains filters from a DataSet column. Once you have added one of these cards to a page, you can click any of the filters in the card to apply that filter to all of the cards in the page. With Slicer and Checkbox cards, you can apply as many filters as you want. With Radio Button cards, you can apply only one filter at a time.

You can deactivate a filter by clicking on it a second time. 

The following animated GIF shows an example of this. Here, marketing manager Scott wants to view Eloqua campaign data for email and social media channels. Instead of having to configure page filters, all Scott has to do is click all of these filters in the Slicer cards. He clicks "Email" and "Social Media" in the "Eloqua: RT Marketing" slicer card. All of the other cards in the page are then filtered accordingly.   

slicer.gif  

(If you would like to download a full-size version of this GIF, just click on it.) 

For information about building Slicer, Checkbox, and Radio Button cards, see Slicer, Checkbox, and Radio Button Cards.

Range Selector Cards

Range Selector cards let users filter all cards on a page to reflect a selected range of values or dates. A slider appears with a minimum and maximum value. When a user changes these minimum and maximum values, all cards update to show data within the new range. In the following animated GIF, the user sets the minimum value (which was originally set to 2,000 by the card creator) to 3,011, and the maximum value (originally 4,998) to 3786. All of the other cards in the page update to reflect the new range. 

range.gif  

(If you would like to download a full-size version of this GIF, just click on it.) 

For information about building Range Selector cards, see Range Selector Card.

Date Selector Cards

By default, a Date Selector card displays a series of dates in calendar format, either in a yearly or monthly view (depending on settings you have applied in Chart Properties). You can click and drag over a range of dates to filter all other cards in the page to show data for those dates. In the following animated GIF, the user highlights all dates from April 1st to August 31st in the "Street Metrics Date Selector" card. The four other cards in the dashboard reflect this selected range.   

date_selector.gif  

(If you would like to download a full-size version of this GIF, just click on it.) 

Alternately, you can click the Presets link on the card to display a number of premade date filters, such as "This week," "Last year," etc. 

date_selector_presets_link.png

date_selector_presets.png

You can show different premade filters by clicking the blue links over the buttons ("Weeks," "Months," etc.). 

You can clear date filters from a Date Selector card by clicking the Clear link or by mousing over the card and clicking date_selector_filter_off.png

For more information about building Date Selector cards, see Date Selector Card.