Reviewing and Applying a Keyset as a Visual Filter
You can review and apply a keyset as a visual filter to visuals that use the same or different data sources. The visuals will be limited to records containing values stored in the keyset.
|To apply a keyset to a visual, the data source for the target visual must include a field storing the same data as the key field used for the keyset. The key field is defined when the keyset is created. See Creating a Keyset.|
Keysets can be applied to all the visuals on a dashboard only if the dashboard contains visuals that use the same data source.
To review and apply a keyset as a visual filter:
For the purposes of this procedure, supposed you want to list the canceled flights from Virginia airports. Assuming you have previously created a keyset containing a list of airport codes, (see Creating a Keyset), we will apply it to a bar chart showing canceled flights nationwide:
- 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.
Locate the data field in the Filters sidebar list that contains the same kind of data as the data in the keyset you want to use. In our example, it would be Origin Airport Code.
The Filters sidebar displays filter options that can be applied for the selected data field.
Select the Keysets tab. The keysets and saved filters defined in your environment are listed. In our example, the keyset Virginia Airport Codes is listed.
Select the keyset you want to apply. Details about the keyset appear on the Filters sidebar.
You can sort the data in the keyset as needed by selecting the up and down arrows () in the Preview area. This sort has no effect on the visual result set when the keyset is applied.
Select . The visual is filtered by the keyset data. In our example, it shows the canceled flights from Virginia airports.
Select the x in the upper right corner of the Filters sidebar to close it.