(v23) Use Keysets

Use Keysets

This applies to: Visual Data Discovery

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.

• Apply keyset filters 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.

• You can update a keyset at any time by uploading new values for the keyset.

Note: 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.

• Create a Keyset
• Create a Keyset From the Visual Result Set
• Create a Keyset From a Data Point
• Create a Keyset From a CSV File
• Review and Apply a Keyset as a Visual Filter
• Delete a Keyset
• Upload Keyset Data From a CSV File Using the API
• Update Keyset Values From a CSV File Using the API