> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-5/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/self-service-visualization-5/applying-filters/global-filter.md).

# Global Filter

This page explains the Global Filter functionality available for the reports.

The Global Filter applies a selected parameter to the entire report, affecting all views that are sensitive to the chosen filter criteria. It is available on the final page of the report and ensures consistent filtering across all relevant Views.

{% hint style="success" %}
*Check out the illustration to understand the Global Filter functionality.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FdNCOQk2mD5fzHIEimL20%2FApplying%20Global%20Filter%20Criteria.mp4?alt=media&token=067f2259-2b44-4981-8490-e905e96709ad>" %}
Applying ***Global Filter Functionality***
{% endembed %}

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>  The selected Report to explain the functionality here contains Views based on two different Data Stores. The First 5 Views are based on the NLP\_hiring\_data\_Aug1, and the sixth View is based on the Sample Data Store.*&#x20;
{% endhint %}

## Applying Global Filter

* Navigate to a Report.
* Click the ***Global Filter*** icon provided in the menu panel of the selected report.
* A ***Filter*** panel opens, displaying a list of values that can be used as a filter condition.
* Click on a Dimension value.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2F2h9eNqLKgSyhoYG5OSLW%2Fimage.png?alt=media&amp;token=999e6b1e-7c46-4723-9ddd-efa9d085d54f" alt=""><figcaption></figcaption></figure>

* A list containing all the sub-dimensions are displayed (Clicking a measure or time dimension would display the related fields).&#x20;
* Select the ***In*** option from the drop-down menu to apply the filtering condition. (E.g., the below-given image displays ***In*** as the selected option so that the report gets filtered as per the chosen sub-dimension(s).
* Select the sub-dimensions using the check boxes (if a Dimension is selected).&#x20;
* Click the ***Apply*** icon.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FiekgxqqbmekXo5aVTLGQ%2Fimage.png?alt=media&amp;token=fd77a45f-875c-45ea-93d6-dd8114aff2b6" alt=""><figcaption><p><em><strong>pplying a Global Filter condition</strong></em></p></figcaption></figure>

* The ***Global Filter*** icon gets highlighted.
* The concerned ***Views*** of the selected report get customized as per the applied ***Global Filter*** condition. E.g., All the concerned ***Views*** are filtered by the selected Global filter value in a report. In this report,  the first Five Views are modified, and Six View is excluded from the Global Filter as it is based on a different Data Store.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FMabF1PDfANbasxEapyJA%2Fimage.png?alt=media&amp;token=e803d27e-a8e6-412f-bb7b-cccbd2db068f" alt=""><figcaption><p><em><strong>All the saved Views get filtered as per the applied Global Filter</strong></em></p></figcaption></figure>

## Filtering with Not In Option

* Click the ***Global Filter*** icon provided on the final screen of a report.
* A filter panel opens, displaying a list of values that can be used as a filter condition.
* Click on a Dimension to display a list containing all the sub-dimensions (Clicking a measure or time dimension would display the related fields).
* Select the ***Not In*** option from the drop-down menu to apply the filtering condition. (E.g., the below-given image displays ***Not*** ***In*** as the selected option so that the report gets filtered as per the not selected sub-dimension(s).
* Select sub-dimension(s) using checkmark(s).
* Click the ***Apply*** icon.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FWYbR26dy9L2eUiUh58Mt%2Fimage.png?alt=media&amp;token=d5633bf6-2fc2-4a41-a3c8-cec3cd81680a" alt=""><figcaption></figcaption></figure>

* The ***Views*** of a report get filtered by not selected filter conditions. E.g., In this example the Report data gets filtered by the values other than the cities of the Rajasthan.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FQHNL08cSDl5uFWQIvi0G%2Fimage.png?alt=media&amp;token=1a99f40b-dbb7-403e-8ace-998987457e6e" alt=""><figcaption><p><em><strong>Filtered Report Data by not selected Value</strong></em></p></figcaption></figure>

## Filter Panel

The ***Global Filter*** provides an option to Attach the selected filter value to the filter panel.&#x20;

* The ***Filter*** panel opens by clicking the Global Filter icon.
* Click the ***Attach to filter panel*** icon for a selected filter condition.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FtkkldG0zM5BouGUywsIj%2Fimage.png?alt=media&amp;token=39c9faa9-62b1-42cf-abe3-1e8414667a60" alt=""><figcaption><p><em><strong>Accessing the Attach to filter panel option</strong></em></p></figcaption></figure>

* The concerned filter value gets attached to the top filter panel.
* The ***Attach to filter panel*** turns blue.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2Fb22SqKcs5s06GkD0p1SD%2Fimage.png?alt=media&amp;token=4afaa17c-18e7-4f67-902d-b207819f58be" alt=""><figcaption></figcaption></figure>

* Choose the sub-value for the attached filter from the top filter panel.
* Click the ***Apply*** option given at the top of the Report.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FyWjVI3UAI3xjyo24ix6P%2Fimage.png?alt=media&amp;token=827cd2ab-a2e8-4364-a7be-af67bef34d09" alt=""><figcaption><p><em><strong>Applying Filter Options using the Filter Panel</strong></em></p></figcaption></figure>

* The selected value/sub-value gets applied to all the concerned View of the Report.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FT0maKMeTJXtqOyNreJKs%2Fimage.png?alt=media&amp;token=37702fe9-0f84-415c-8703-a65381693d0c" alt=""><figcaption><p><em><strong>Filtered Report</strong></em> </p></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">**Please Note:**</mark>*

* The ***Global Filter*** is applied sequentially based on user selections. For example, if the first filter is by Source (Referral, Orgspire, CareerNet) and the second by Gender (Female), the report will display data for female employees from these specific sources.
* *If the **Exclude Global Filter** option is enabled for a View, it remains unaffected by the Global Filter criteria.*&#x20;
* *Users can insert **Views** from different data stores in a single report. In a report with Views from multiple data stores, applying a Global Filter only affects the Views from the specific data store where the filter conditions are selected; Views from other data stores remain unaffected.*
* *The **Global Filter** panel displays all available filter values across the data stores by default.*
* *Click the **Refresh** icon to Refresh Views and remove the effect of an applied Global Filter criteria from the chosen Report.*
  {% endhint %}