---
title: "Pre-filter Data"
slug: "pre-filter-data"
updated: 2022-07-05T15:54:10Z
published: 2022-07-05T15:54:11Z
canonical: "docs.preset.io/pre-filter-data"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.preset.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Pre-filter Data

## Overview

In this article, we will learn how to limit the availability of specified values within a filter using the **Pre-filter available values** configuration option.

---

## Filter Configuration Options

The following configuration options are available for these filter types:

|  | Value | Numerical Range | Time Range | Time Column | Time Grain |
| --- | --- | --- | --- | --- | --- |
| [Parent-child](/v1/docs/hierarchal-filter) | ✔ |  |  |  |  |
| Pre-filter available values | ✔ | ✔ |  |  |  |
| [Sort filter values](/v1/docs/sort-filter-value) | ✔ |  | ✔ | ✔ | ✔ |
| [Single value](/v1/docs/single-value-range) |  | ✔ |  |  |  |

---

## Pre-filter Data

          **Option is available for these Filter Types**: Value, Numerical Range

          

In the [Parent-child Filter](/v1/docs/hierarchal-filter) article we used the **Values are dependent on other filters** option to create a parent-child relationship between the **Select Platform** and **Select Genre** value filters, respectively.

Recall that, in the **Select Platform** filter, all available platform values were available as selectable options in the drop-down (e.g., 2600, 3DO, 3DS, etc.).

What if we wanted to only display PlayStation values (i.e., PS2, PS3, and PS4) in the **Select Platform** filter? This can easily be done via the **Pre-filter available values** setting, which simply limits the number of selectable values in a filter.

Let's dive in and see how it works!

Start by selecting the "Select Platform" filter we created earlier and, in the *Filter Configuration* panel, select **Pre-filter available values**. A **Pre-Filter** field appears.

Select the **Pre-Filter** field and a sub-menu appears featuring a pair of tabs: **Simple** and **Custom SQL**.

The **Simple** tab enables you to correlate a column with a defined value via operators (e.g., equals, not equals, <, >, etc.). The **Custom SQL** tab enables you to enter your own custom SQL code to specify pre-filtered values for a column.

In this example, we want to limit the options to just PS2, PS3, and PS4. To do this, select the column **Platform**, the operator **IN** (since there will be multiple options), and the values **PS2**, **PS3**, and **PS4**. If you wish to also filter by time range, just select the **No filter** button and configure accordingly.

When done, remember to select **Save** for the pre-filter and **Save** again for the filter as a whole!

The configuration should look as follows:

![New_Pre-Filter_1](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/New_Pre-Filter_1.png)

Navigating back to the dashboard, you can see that the **Select Platform** filter now only displays the three pre-filtered values:

![New_Pre-filtered_Results](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/New_Pre-filtered_Results.png)

---

## Related Topics

[Dashboard Filtering](/v1/docs/dashboard-filtering) [Filter Types](/v1/docs/filter-types) [Parent-child Filter](/v1/docs/hierarchal-filter) Pre-filter Data [Sort Filter Values](/v1/docs/sort-filter-value) [Single Value Range](/v1/docs/single-value-range) [Filter Tooltip](/v1/docs/filter-tooltip) [Managing Values](/v1/docs/managing-values) [Scoping a Filter](/v1/docs/scoping-a-filter) [Cross-filtering](/v1/docs/cross-filtering) [Managing Filters](/v1/docs/managing-filters)