Filtering and sorting the attributes in Explore

Within Explore, you can decide which attributes you want to see, and the order to display them in. If you are within a project, these preferences carry over to Transform, and also apply to all users of the project.

Setting attributes as hidden or favorite

As you look over the attributes, you may discover attributes that you are very interested in, or that don’t have as much value and you don't want to see.

For attributes that you are most interested in, you can click Add to favorites in the attribute panel. These attributes move to the front of the sorted list.

For attributes that you are not at all interested in, you can hide the attribute by clicking click Hide from view in the attribute panel. This removes the attribute from the display.

The favorite and hide options display when you hover over an attribute tile, and when you display the attribute details.

If you mark an attribute as favorite or hidden, when exploring the data set from the Catalog, the attribute displays as a favorite or hidden for all users who explore the data set from the Catalog.

Filtering the displayed attributes

The attribute filter bar allows you to determine which attributes to display.

You can show or hide attributes based on:
  • The data type for the attribute.

    Select the check box next to each data type to include.

  • The first letter of the attribute name.

    Type an attribute name into the search box to locate attributes whose names start with that letter.

  • Whether the attribute is starred or hidden.

    To only show starred attributes, click Favorites. To only show hidden attributes, click Hidden.

You can also use the filter field to filter the attributes based on text in the attribute name.

Sorting the displayed attributes

When you sort based on an attribute, the selected attribute is moved to the front of the list, and the other attributes are displayed in order based on that attribute. In Explore, you can sort the attributes:
  • Based on an algorithm that places attributes with more information potential at the top of the list. This is the default.
  • Alphabetically by name
  • Based on the relationship to a selected attribute.

    This sort suggests how closely related the attribute is to others in the data set and sorts the attributes accordingly. This sort suggests what one attribute can tell you about the distribution of other attributes. For example, you might sort a complaint attribute in a manufacturing data set and find that a supplier name attribute is closely related.

    This sort does not work with attributes that have hundreds of distinct values, so those attributes are marked as ineligible for sort by relationship. Also, this sort does not evaluate null values; attributes that have a large number of null values are moved toward the end of the sorted list.

To sort alphabetically by name, select By name from the Sort list.

To sort based on the relationship to a selected attribute, select Relationship to an attribute from the Sort list and choose an attribute to sort by.