There are a couple of ways to apply filters to your datasets in SpatialKey.
- The first option is to apply a dataset filter. Applying dataset filters is a handy way to cut your dataset into a smaller subset before you get to the dashboard. You could use this feature to filter out null records or records that didn’t geocode well, just to name a couple of examples.
- The second option, which is the most common filtering option, is to apply filters from within your dashboard. This option provides for flexibility of changing and applying filters while in your dashboard – in the first option described above, you will need to close your dashboard in order to edit the filter. To learn more about filtering options from within a dashboard, check out Filtering in SpatialKey.
To begin applying a dataset filter (first option above), select the Manage Data tab and find your dataset. Click on the gear icon to view data settings and select the “Advanced Settings” option on the left side of the screen. Note: you will only see this option if you are the Creator/Editor or Contributor of the dataset.
Click to add a filter for a column in your dataset. In the example below, the “county” column was selected.
Apply a filter based on what the column starts with, equals, or select to only include records where the column is not blank.
You can also choose “custom selection”, which allows you to select exact values from a unique value list pod.
After selecting your filter(s), “save changes” to apply the filter(s).
That’s is, you’re all done applying filters. Now when you open your dashboard, you will only see the records that meet the set filter criteria.