Apply Wild Card Filters to a Visual or Dashboard
Wild card filters are row-level filters you can use to filter the data on your dashboard visuals. Wild card filters allow you to filter and analyze the data in a visual that matches specific combinations of character patterns.
When working with multiple filter types on the same visual, row-level filters (including wild card filters) are applied first to a visual, keyset filters are applied second, and group filters are applied last on the aggregated result set.
Many Composer connectors support wild card filters, but support for case-sensitivity in wild card filters varies depending on the connector's data store.
Support for this feature by Composer connectors is shown in the following table.
Key: Y - Supported; N - Not Supported; N/A - not applicable
|Apache Phoenix Query Server (QS)||Y|
|Microsoft SQL Server||Y|
|Real Time Sales||Y|
To apply a wild card filter to a visual or dashboard:
- 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, table (raw data), 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 Maintain 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.
- The Value tab allows you to select a filter value for the attribute. See Apply Row-Level Filters for instructions on using a regular row-level filter.
- The Wildcard tab allows you to specify a wild card filter for the attribute. Continue following the steps in these instructions.
- The Keyset tab allows you to select a keyset filter for the attribute. See Use Keysets for instructions on using keysets in a filter.
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 Access the Derived Field Editor from the Filters Sidebar and Access the Custom Metrics Editor from the Filters Sidebar.
Select the Wildcard tab to create a row-level wild card filter.
Select an operator from the drop-down menu for the Operator box on the Wildcard tab.
Operator Data is included in the visual... Contains When the data in the filter attribute you selected contains the wild card string you will specify in the next step. Does Not Contain When the data in the filter attribute you selected does not contain the wild card string you will specify in the next step. Begins With When the data in the filter attribute you selected begins with the wild card string you will specify in the next step. Does Not Begin With When the data in the filter attribute you selected does not begin with the wild card string you will specify in the next step. Ends With When the data in the filter attribute you selected ends with the wild card string you will specify in the next step. Does Not End With When the data in the filter attribute you selected does not end with the wild card string you will specify in the next step.
In the Value box, type a string of characters that represents the wild card string for the filter. Data is included in the visual when the data in the filter field meets the condition set by this operator and the wild card string you specify.
By default the Case Sensitive slider is on (selected). When this option is selected, the wild card filter includes data in the visual only if the filter attribute data exactly matches both the value of the wild card string and the case of the wild card string value. Slide the option off if you do not care if the visual data exactly matches the case of the wild card string.
If you want to specify another wild card value, select next to the Values title on the Wildcard tab. Then repeat Steps 5-7 above for the new wild card value. Multiple wild card values are treated as OR operations. A record can meet the filter criteria specified by any of the wildcard values to be selected for filter processing.
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.
Optionally, repeat these steps to apply additional filters to the visual or dashboard.
See Remove a Filter from a Visual or Dashboard for information on removing a wild card filter from a visual or dashboard.