> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/functionality/data-set/data-filtering.md).

# Data filtering

Data filtering enables you to refine your data to display only specific subsets based on specific criteria. By filtering your data, you can quickly identify trends, patterns, and outliers, and make better-informed decisions, presented in a concise dataset.

{% stepper %}
{% step %}
To filter data from your columns, you must click on the filter button:

<div align="left"><figure><img src="/files/NOvgUmAmRXLXskFonKHm" alt="" width="375"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}
Click the first dropdown box and select any of the columns you wish to filter

<div align="left"><figure><img src="/files/noONFM1Cyyp1JWWO3Lpo" alt="" width="375"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}
Select your desired operator (Note: The operator options change depending on the selected column's data type). For the String data type, the operators available are the following

<div align="left"><figure><img src="/files/8X030HyfMFBcMqSCJA5H" alt="" width="375"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}
Insert your criteria
{% endstep %}

{% step %}
Press the Apply Filters button or add more filters by pressing the "AND" or "OR" buttons, depending on the logic you want to specify
{% endstep %}
{% endstepper %}

<details>

<summary>Check the example</summary>

For example, we want to fetch videos with more than a certain number of views and a larger than given watch time, then our filter should look something like this:

<div align="left"><img src="https://d33v4339jhl8k0.cloudfront.net/docs/assets/57fbf3029033600277a688ab/images/68ad805921d3d80c18c59df2/file-LV6etVvewP.png" alt="" width="375"></div>

But if we want to fetch videos with more than a certain number of views and a larger than given watch time, AND more than a certain percentage, then it should be something like the following:

<div align="left"><img src="https://d33v4339jhl8k0.cloudfront.net/docs/assets/57fbf3029033600277a688ab/images/68ad802ab48d4e6880fc2500/file-eott2JBg3K.png" alt="" width="375"></div>

</details>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.coupler.io/functionality/data-set/data-filtering.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
