Effective Business Intelligence with QuickSight

Filtering data using SPICE

With SPICE, we can refine data in a dataset. Each filter applies to only one field, which can be a regular or a derived field. We can apply multiple filters to the same field or different fields. Let's review this functionality in detail.

Adding new filters

Let's see how to use the filtering features on the zip code salary data. We will filter the dataset for records that have median income between $30,000 and $60,000 and for states in the north east (NH, MA, NY, CT, and NJ).

We will achieve this in two key steps: filter on the numeric medianincome and then filter on the text field statecode.

Filter on medianincome

Follow these steps to add a filter on the numeric field medianincome:

1. On the data preparation page, click on ...