Use Keysets
Keysets are collections of unique data values that can be saved and used in further analysis of your data. They allow you to perform multipass and multisource filtering of your data.
You can create a keyset by selecting a single field for the keyset from visual data. Filtering the visual data before creating the keyset limits the unique data values the keyset includes. The field you select for the keyset is known as the keyset's key field. For example, from a visual that lists airport codes nationwide but that has been filtered to show only Virginia airports, you can create a keyset listing only Virginia airport codes by selecting the airport code field as the keyset's key field.
You can also create and update a keyset from a CSV file.
You can apply a keyset as a visual filter. This limits the visual's result set to records containing values stored in the keyset. Keyset filters can be applied to visuals from the same or different data sources. However, the data source for the target visual must contain a field storing the same kind of data as the keyset's key field.
When working with multiple filter types on the same visual, row-level filters (including wildcard filters) are applied first to a visual, keyset filters are applied second, and group filters are applied last on the aggregated result set.
To control whether keysets can be created or managed from a visual, use the interactivity sidebar. See Control How Users Interact With a Visual.
See the following topics.
Comments
0 comments
Please sign in to leave a comment.