# Filters using common columns

Columns that are shared across multiple Business Views are distinctly marked with a Venn diagram for easy identification.

<figure><img src="/files/cprZE39cPa2hJd4d7Pma" alt="" width="375"><figcaption><p>Indicating the common columns</p></figcaption></figure>

If you select any of the common columns that exist in multiple Business Views, then the filter will be applied to all the charts created from those Business Views. With this ability, you can intersect disparate Business Views without necessarily joining them.

1. Consider a Vizpad created with multiple Business Views - *Sales, Marketing,* and *Support*.
2. If you filter using a common column (e.g., *<mark style="color:red;">"revenue"</mark>*) from a Business View (e.g., *Sales*), then the filter will be applied to all the corresponding charts (whose Business View has a column named *<mark style="color:red;">"revenue"</mark>*).

{% hint style="success" %}
If only two Business Views (*Sales* and *Marketing*) have a column named *<mark style="color:red;">"revenue"</mark>*, then the filter will be applied to charts created using *Sales* and *Marketing*.
{% endhint %}

3. The charts that were created using Business Views other than the *Sales* Business View, will have an additional circle of color (representing *Sales*) in their chart.

{% hint style="success" %}

* The chart from *Sales* Business View will have one circle of color (indicating *Sales*).
* The chart from *Marketing* Business View will have two circles of color (indicating *Sales* and *Marketing*).
* The chart from *Support* Business View will have one circle of color (indicating Support, since it doesn’t have a column named *<mark style="color:red;">"revenue"</mark>*).
  {% endhint %}

3. The charts with more than one circle of color indicate that more than one Business View has been involved.
4. Different charts with the same circles of color indicate that those charts were created using the same Business View.

<figure><img src="/files/XjgWdkHx92IjxhOP56L0" alt=""><figcaption><p>Applying filters using common columns</p></figcaption></figure>

If you create a chart using a Business View (e.g., "*Customer Success*") that shares a common column (like <mark style="color:red;">"</mark>*<mark style="color:red;">revenue"</mark>*) for which a filter has already been applied, the chart will automatically use that *<mark style="color:red;">"revenue"</mark>* filter. This ensures your data remains consistent, and filters get reflected with newly created charts across different Business Views.

Thus, you can select a chart created using any Business View and apply a filter using the common columns from a different Business View.


---

# 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://help.tellius.com/tellius-6.3/vizpads-explore/applying-global-filters/filters-using-common-columns.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.