# Filters

Filters are one of the core features within the data tables, providing you with the ability to refine and segment large datasets to focus on specific aspects. Essentially, a filter is a set of criteria applied to data to isolate particular elements based on defined parameters. This tool is crucial for managing and interpreting data more effectively, as it helps in extracting meaningful information from potentially overwhelming datasets.

Filters are applied individually to each [dimension](/managing-advertising-accounts/modules/cross-module-components/data-tables/data.md#dimensions) or [metric](/managing-advertising-accounts/modules/cross-module-components/data-tables/data.md#metrics) (organized in [columns](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/columns.md)). By applying filters to these individual elements, you can tailor analysis to specific areas of interest. For example, you can apply a filter to view sales data for a particular portfolio or analyze click data originating from a specific campaign.

This individual application of filters to each dimension or metric allows for a high degree of customization in your data analysis. You are free to combine multiple filters across different dimensions and metrics to create complex, layered data views. This approach enables deep dives into specific data segments, facilitating more detailed and targeted analysis, which is essential for informed decision-making and strategic planning.

<div align="left" data-full-width="false"><figure><img src="/files/YptYh96oujFkhoAglGk2" alt=""><figcaption></figcaption></figure></div>

### Filtering data

Filters for each column are defined by sets of parameters, allowing you to tailor the data view according to your specific needs. You have the ability to incorporate more than one set of parameters and use [operators](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/filters/operators.md) to combine them in various ways. By stacking multiple sets of parameters, you can refine your views to target very specific datasets. This multi-layered approach to filtering is essential for deep data analysis, enabling users to drill down into the most relevant details.

To filter the current data table, click the "filters" button in the [actions bar](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar.md).

#### Adding/removing sets of parameters

* [x] **Adding parameters:** To introduce the first set of parameters, click the "+" icon to the right of the desired column. It's important to note that only visible columns are available in the filters modal. Additional sets of parameters can be added using the same "+" button, allowing for more complex filtering strategies.

  <div align="left"><figure><img src="/files/X2NOpoYdeeck3lMPwRAl" alt=""><figcaption></figcaption></figure></div>
* [ ] **Removing parameters:** To remove a set of parameters, simply use the "x" button next to it. This flexibility ensures that adjusting your filter criteria is a straightforward process.

  <div align="left"><figure><img src="/files/FUKl8I1jgJKeYi7gwGcq" alt=""><figcaption></figcaption></figure></div>

#### Defining each set of parameters

Each individual set of parameters includes input fields for:

1. [**Conditions**](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/filters/conditions.md)**:** Here, you select from a dropdown menu the specific condition (like 'equals', 'contains', etc.) that applies to the data.&#x20;
2. [**Nested operators**](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/filters/operators.md#nested-operators)**:** Another dropdown menu where you select how the conditions will interact (such as 'any', 'all').&#x20;
3. **Values:** An input field where you specify the value relevant to the chosen condition, which can either be a string (text) or a number.

<div align="left"><figure><img src="/files/erJMowtg9nyZiohoyp3t" alt=""><figcaption></figcaption></figure></div>

Stacked sets of parameters will trigger the primary operators' function, which combines these sets in different ways, as detailed in the [operators section](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/filters/operators.md). This layered approach is key for creating precise and tailored data views.

<div align="left"><figure><img src="/files/ax6LhDgquXmcWxrcjtm4" alt=""><figcaption></figcaption></figure></div>

{% content-ref url="/pages/Plx01jh6Yq6z5DEWNxIK" %}
[Conditions](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/filters/conditions.md)
{% endcontent-ref %}

{% content-ref url="/pages/vJrxEshL5VrahvQ7yko6" %}
[Operators](/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/filters/operators.md)
{% endcontent-ref %}

#### Implementing/discarding changes

* [x] **Apply:** Implements the changes made in the filter conditions and operators. Once you have set your desired conditions, clicking "Apply" updates the data view to reflect these filters, showing only the data that meets the specified criteria. This function is crucial for the effective application of complex filtering.
* [ ] **Clear:** Resets all current filters, restoring the dimension/metric to its default state with no filters applied. This feature is particularly useful when you wish to start the filtering process anew or swiftly remove all current conditions. To make these reset changes effective, you also need to apply them.
* [ ] **Cancel:** Returns you to the data table without applying any changes. This option is useful when you decide not to proceed with the filtering adjustments you were exploring.

<div align="left"><figure><img src="/files/EHl6FgvnJ4xz5291peLa" alt=""><figcaption></figcaption></figure></div>

{% hint style="info" %}
To filter a column quickly without opening the filters modal and configuring multiple filters, you can use the column filtering controller instead.
{% endhint %}

***

{% content-ref url="/pages/Be0o9T6YccXxKH5fQd4A" %}
[Filtering controller](/managing-advertising-accounts/modules/cross-module-components/data-tables/controllers-bar/filtering-controller.md)
{% endcontent-ref %}


---

# Agent Instructions: 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.advertisingbeast.com/managing-advertising-accounts/modules/cross-module-components/data-tables/actions-bar/filters.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.