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.
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
.
Follow these steps to add a filter on the numeric field medianincome
:
On the data preparation page, click on the Filters pane.
Next click on New filter.
Next select
medianincome
as shown in the following screenshot:Figure 3.16: Filter on medianincome
Click on the text Equals - none, which will then expand the various filter options, as shown in the next screenshot...