Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

Where Function in Tableau?

Cody Schneider••8 min read

If you're coming to Tableau from a SQL or programming background, your first instinct for narrowing down data is probably to look for the WHERE clause. While Tableau doesn't have a literal "WHERE" function you can type out, it offers powerful and intuitive ways to achieve the exact same result: filtering your data to focus on what matters most. This guide will walk you through the various methods Tableau uses to mimic the functionality of a WHERE clause, from basic drag-and-drop filters to more complex conditional logic.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Tableau Doesn't Have a "WHERE" Function

Tableau is fundamentally a visual analytics platform, designed for exploration and interaction rather than line-by-line coding. Instead of writing queries like SELECT SUM(Sales) FROM Orders WHERE Region = 'West', you build visualizations by dragging fields (or "pills") onto different shelves. The filtering process follows this same visual, interactive paradigm.

The core idea is the same: you define conditions to include or exclude specific rows of data from your analysis. Tableau just handles this through a user interface with shelves, a filter card, and dialog boxes. Let's break down how you can apply these "WHERE" conditions in practice.

The Foundations: Using the Filters Shelf

The most direct equivalent to a WHERE clause in Tableau is the Filters Shelf. This is where you place any field you want to use as a filter for your visualization. By dragging a field here, you tell Tableau, "I only want to see data WHERE this field meets certain criteria."

Imagine you have a dataset of global sales and you want to analyze performance only in the United States. In SQL, you'd write WHERE Country = 'United States'. Here’s how you do it in Tableau:

  1. Connect to Your Data: Start with your dataset loaded into Tableau.
  2. Identify the Filtering Field: Find the dimension you want to filter by in your Data pane. In our case, this would be a field named Country or Country/Region.
  3. Drag to the Filters Shelf: Drag the Country pill from the Data pane and drop it directly onto the Filters shelf, located just above the Marks card.
  4. Define the Criteria: As soon as you drop the pill, a dialog box will pop up. This window allows you to set your filter conditions. In the "General" tab, you'll see a list of all available countries in your dataset. Simply check the box next to "United States."
  5. Apply the Filter: Click "OK" or "Apply." Your entire visualization will instantly update to show data exclusively for the United States. You have successfully applied your WHERE clause.

The field you filtered on now appears as a pill on the Filters shelf, and you can right-click it to edit the filter anytime.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Filtering Dimensions vs. Filtering Measures

Just as SQL handles filtering text and numbers differently, Tableau provides different options based on the type of data in your field (whether it’s a dimension or a measure).

Filtering on a Dimension (Categorical Data)

When you drag a dimension like Product Category, Region, or Customer Name to the Filters shelf, you're usually working with discrete text values. The dialog box gives you a few options:

  • General: Pick specific values from a list (e.g., select 'Technology' and 'Office Supplies' but exclude 'Furniture').
  • Wildcard: Filter based on text matching, similar to SQL's LIKE operator. You can filter for values that contain, start with, end with, or exactly match a string of text. For instance, you could find all products containing the word "Chair."
  • Condition: Apply a filter based on a rule, such as finding all Customers whose SUM(Sales) is greater than $50,000.
  • Top: Filter to see the top or bottom N records based on a measure. For example, show the "Top 10 Products by Profit."

Filtering on a Measure (Numerical Data)

When you drag a measure like Sales, Profit, or Quantity to the Filters shelf, Tableau first asks how you want to aggregate it (e.g., SUM, AVG, MEDIAN). After you choose, you get a different dialog box for filtering a continuous range of numbers.

Let's say you want to see orders where the sales total was at least $500.

  1. Drag the Sales measure to the Filters shelf.
  2. Choose an aggregation in the pop-up, usually SUM.
  3. In the next dialog box, you'll be able to set the criteria. Choose "At Least" and type 500 into the box.
  4. Click "OK." Your view now only includes data points that meet this condition, effectively running a HAVING SUM(Sales) >= 500 clause.
GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Complex Logic with Calculated Fields

What if you need a WHERE clause with multiple AND or OR conditions? This is where Tableau's Calculated Fields shine. A calculated field lets you create a new field based on a formula, and you can then use that new field for filtering.

The IF and IIF functions are your best friends here. They work like a CASE statement in SQL to categorize your data.

Example: You want to identify "high-value corporate customers in the West." Your conditions are:

  • Segment must be "Corporate"
  • Region must be "West"
  • The total Sales must be greater than $1,000

You can combine these into a single "True/False" calculated field to use as a filter.

  1. Create a Calculated Field: Right-click anywhere in the Data pane and select "Create Calculated Field."
  2. Write the Formula: Give your calculation a name, like "High-Value West Corporate." Then, enter the following logical statement:
[Segment] = "Corporate" AND [Region] = "West" AND [Sales] > 1000

This formula evaluates each row of your data and returns True if all three conditions are met, and False otherwise.

  1. Use the Calculation as a Filter: Drag your new "High-Value West Corporate" pill from the Data pane onto the Filters shelf.
  2. Apply the Filter: A small dialog box will appear asking which values to include. Check the box for True and click "OK."

Your entire view is now filtered as if you had written a complex WHERE clause. This method is incredibly flexible, allowing you to build virtually any logical condition you need.

Applying a "WHERE" Clause Globally with Data Source Filters

Sometimes you need to apply a filter across your entire workbook. For example, you might want to exclude test data or cancelled order statuses from every single one of your analyses. Instead of adding a filter to every worksheet, you can use a Data Source Filter.

A Data Source Filter is exactly what it sounds like: a filter applied directly at the data source level. It's the most efficient way to filter because it removes the data before it even loads into worksheets.

Here’s how to set one up:

  1. Go to the Data Source tab in the bottom-left corner of your Tableau workspace.
  2. In the top-right corner, in the "Filters" section, click "Add."
  3. The "Add Filter" dialog box will appear. Select the field you want to filter on, for example Order Status.
  4. Set your condition. For instance, from the list of statuses, you could choose to "Exclude" the Cancelled status.
  5. Click "OK." This filter is now active for every worksheet and dashboard using this data connection, a permanent WHERE clause for your entire workbook.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Controlling the Order: Context Filters

In SQL, the WHERE clause is typically processed before aggregations or other operations. Tableau has its own execution pipeline known as the Order of Operations. For the most part, this happens automatically behind the scenes, but sometimes you need to control it.

A Context Filter is your tool for this. When you add a filter "to context," you tell Tableau to create a temporary, smaller dataset based on that filter before running other filters like Top N or Include/Exclude filters in the view.

When would you use this? A classic example is finding the "Top 10 Products by Sales within the Technology category."

  • Without a context filter: If you filter for Category = "Technology" and then apply a "Top 10 Products by Sales" filter, Tableau first finds the top 10 products across all categories, and then checks which of them happen to be in the technology category. You might end up with only two or three products.
  • With a context filter: If you right-click the Category = "Technology" filter and select "Add to Context," Tableau first narrows your data down to only technology items. Then, when it finds the top 10, it finds the top 10 from within that temporary "technology only" dataset.

Adding a filter to context is simple: right-click the pill on the Filters shelf and choose "Add to Context." The pill will turn gray, indicating it is now a high-priority WHERE condition that runs before other dimensional filters.

Final Thoughts

Tableau may not have a function labeled "WHERE," but its filtering capabilities are just as powerful, if not more flexible. By understanding how to use the Filters Shelf for simple conditions, Calculated Fields for complex logic, Data Source filters for global rules, and Context Filters to control the sequence, you can effectively replicate and expand upon anything you used a WHERE clause for in SQL. It's simply a shift from a code-first mindset to a visual one.

Mastering the filtering system of tools like Tableau takes time, but it’s essential for accurate analysis. We knew this learning curve could be a major hurdle for teams who need answers fast. That’s why we built Graphed to handle the complexity for you. Instead of figuring out which filter type to use, you can just ask in plain English: "Show me my top 10 products by sales in the West region for corporate customers" and get an interactive dashboard instantly. It translates your business questions into the right analysis, without the steep learning curve.

Related Articles