Setting an Attribute Filter
You can filter visual data by the values in an attribute.
To set a filter for an attribute:
- To access the visual filter sidebar, select its filter icon () or select Edit Visual from the visual menu () and then select on the sidebar menu.
- To access the dashboard filter sidebar, select its filter icon (). The dashboard-level filter icon is available only when all the visuals are from the same data source.
The Filters sidebar appears showing any filters that have been applied.
Select the Row tab. If the style of your visual is an arc gauge, KPI chart, raw data table, histogram, or map markers chart, the Group tab is available, but you cannot create a group filter because all filters for these visual styles are row-level filters. If you are using the dashboard filters sidebar, the Group tab is not available.
The Saved tab shows saved filters that you can apply to a dashboard or visual. See Maintaining Saved Filters
On the Row tab, select the filter attribute you want to use from the list of available attributes. A second page with three tabs appears in the Filters sidebar.
You can also select to access the Derived Field Editor or the Custom Metrics Editor to create or modify derived fields and custom metrics to be used as filters. See Accessing the Derived Field Editor from the Filters Sidebar and Accessing the Custom Metrics Editor from the Filters Sidebar.
Tab Description Value
The Value tab allows you to select:
- A filter operator (Include or Exclude, depending on whether you want to include or exclude the value from the data).
- An optional custom value. To create and select a custom value, enter the value in the Customize field and select Add. Your custom field is added and selected in the list of possible values. To remove the custom value, uncheck it in the list of possible values. It is removed from the filter and from the list of possible values for the filter.
- One or more values from the list of available values for the attribute you selected. To select all values, select Select All.
Use the search bar to quickly find a value. You can type the name of the value in the Search bar (or characters in the value name) to limit the list of values. A maximum of 1000 values are listed. If no values are listed or if you cannot find your value, type the exact name of the value (as stored in your data) into the Search bar and select to select it. This will force Composer to use this value when sending the query to the data store.
The Wildcard tab allows you to specify a wild card filter for the attribute. See Applying Wild Card Filters to a Visual or Dashboard.
Keyset The Keyset tab allows you to select a keyset filter for the attribute. See Using Keysets for instructions on using keysets in a filter.
After the filter specifics have been specified, select . If you create the filter at the dashboard level, it is applied to all the visuals in the dashboard. Otherwise, it is applied only to the selected (active) visual.