How do I apply two filters to the same field?

You can apply filters to dashboards as either dashboard filters or tile filters. If both types of filters are applied to the same field, the dashboard filter overrides the tile filter.

For example, if you apply the following filters, the dashboard filter will be applied and data for Canada will be included in the dashboard.

• You add a tile filter to a Pie visualization for the Country dimension that excludes data for Canada from the tile.
• You add a dashboard filter for the Country dimension that includes data for Canada in the dashboard.

Detailed steps

There are two methods you can use to ensure that data for Canada is always excluded from the dashboard.

Edit the tiles that the Dashboard filter applies to

1. Open the dashboard in edit mode.
2. Click the Filter Menu for the dashboard filter in the filter bar and select Edit.
3. Click the Tiles To Update tab.
4. From the Field to Filter drop-down list next to the field you want to exclude from the dashboard filter, select Do Not Filter. 
5. Click Update.
6. Click Update on the dashboard page to view the updated the filter settings.
   
7. Click Save.

Create a custom field to filter the tile by

1. Open the dashboard in edit mode.
2. Add your dashboard filter for the desired field.
3. For the visualization you want to add the filter to select Tile Actions > Edit.
4. In the Custom Fields section of the field picker, select Add > Custom Dimension.
5. In the Expression text box, start typing the name of the field to filter on and select it in the autocomplete list.
6. In the Name text box, enter the name of field with "_Filter" appended. For example, Country_Filter.
7. Click Save.
   The new filter is added to the Custom Fields section in the field picker.
8. Hover your mouse over the new custom field and click the Filter by field icon.
   
9. In the Filters panel, configure the desired settings for the filter.
   
10. In the Custom Fields section of the field picker, click on the custom field name if you do not want to include it in your visualization.
11. Click Run and then click Save.
    The filter applied to the custom field will apply to the dashboard regardless of the setting in the dashboard filter.