Amazon QuickSight
User Guide

Adding a Text Filter

You can filter text fields by either choosing field values from a list or by specifying field values.

Use the Filter list filter type to filter by choosing field values. Using this filter type, Amazon QuickSight retrieves a list of the field values for the selected field. You choose the values that you want to filter on, and whether you want to include or exclude records with those values. You also have the options to Select all values, or search for specific values.

To narrow down the values displayed, type a search term into the box above the checklist and choose Search. Search terms are case-insensitive and wildcards are not supported. Any field value that contains the search term is returned. For example, searching on L returns al, AL, la, and LA.

To return to viewing the full set of field values rather than just those that match the search term, choose Search again.

For filter lists, you can refresh the list of field values by choosing the refresh icon.

Use the Custom filter list filter type to specify one or more field values to filter on. You can also choose whether you want to include or exclude records that contain those values. The specified value and actual field value must match exactly in order for the filter to be applied to a given record. You can also choose whether to exclude or include nulls, or show only rows with nulls in this field.

With the Custom filter filter type, you specify a single value that the field value must equal or not equal. If you choose an equal comparison, the specified value and actual field value must match exactly in order for the filter to be applied to a given record. Custom filters also allow you the option to attach a parameter. To use a preexisting parameter, enable the Use parameters setting. For more information about parameters, see Parameterize a Filter.

Details on how to create each type of text field filter are provided in the following sections.

Using a Filter List to Select Field Values

Use the following procedure to create a text field filter for by selecting field values.

Important

You can only filter by choosing field values in cases where Amazon QuickSight can quickly retrieve the full set of values. In cases where you are working with very large record sets and this is not possible, you must filter by specifying field values instead. For more information about filtering with specified field values, see Using a Custom Filter List to Specify Multiple Values and Using a Custom Filter to Specify a Single Value or Parameter.

  1. Choose Filter on the tool bar.

  2. On the Applied filters pane, choose the add filter icon ( + ), and then choose a text field to filter on.

    This creates a new filter with no criteria.

  3. The filter is added to the list of filters. Choose the new filter to expand it.

  4. Choose Filter list for the filter type.

  5. Select the field values that you want to filter on.

    Scroll through the checklist and select or clear values, or toggle the ALL check box to select or deselect all of the values at once.

    To narrow down the values displayed, type a search term into the box above the checklist and choose Search. Search terms are case-insensitive and wildcards are not supported. Any field value that contains the search term is returned. For example, searching on L returns al, AL, la, and LA.

    Choose X in the search box to clear the search term.

    Note

    The filter list can display up to 10,000 values. If you have more than 10,000 values in your list, use a custom filter. For information about custom filters, see Using a Custom Filter List to Specify Multiple Values.

Using a Custom Filter List to Specify Multiple Values

You can use the Custom filter list filter type to specify one or more field values to filter on, and choose whether you want to include or exclude records that contain those values. The specified value and actual field value must match exactly in order for the filter to be applied to a given record.

Use the following procedure to create a text field filter by specifying exact field values.

  1. Choose Filter on the tool bar.

  2. On the Applied filters pane, choose the new filter icon, and then choose a text field to filter on.

  3. Choose the new filter to expand it.

  4. Choose Custom filter list for the filter type.

  5. Type a field value in Enter a value to add, and then choose the add icon.

    To remove a field value from the criteria, choose its delete icon.

  6. (Optional) Repeat Step 5 until you have all of the field values that you want to filter on.

  7. Choose whether to include or exclude records that contain the field values you selected.

  8. Choose how to handle null values in the filtered field. You can choose to include or exclude the values you listed. Alternatively, you can choose to show nulls only.

  9. Choose Apply.

Using a Custom Filter to Specify a Single Value or Parameter

With the Custom filter filter type, you specify a single value that the field value must equal or not equal. If you choose an equal comparison, the specified value and actual field value must match exactly in order for the filter to be applied to a given record. You can also choose how to handle null values in the filtered field. You can choose to include or exclude nulls, or show only rows containing nulls. Alternatively, you can use a parameter with a custom filter.

Use the following procedure to create a text field filter by specifying one field value or parameter.

  1. Choose Filter on the tool bar.

  2. On the Applied filters pane, choose the new filter icon, and then choose a text field to filter on.

  3. Choose the new filter to expand it.

  4. Choose Custom filter for the filter type.

  5. Choose a comparison type.

  6. Choose one of the following.

    • To use a literal value:

      Type a field value in the value field.

      Then, choose how to handle null values in the filtered field. You can choose to include or exclude the values you listed. Alternatively, you can choose to show nulls only.

    • To use an existing parameter:

      Enable Use parameters, then choose your parameter from the drop-down list box.

      You must create your parameters first for them to appear in this list. Usually, you create a parameter, add a control for it, and then add a filter for it. For more information, see Parameters in Amazon QuickSight.

  7. Choose Apply.