How to Use Filters in Looker Report

Filtering your data is how you turn a massive, noisy dataset into clear, actionable insight. In Looker, filters are the tools that let you drill down, segment, and explore your reports to find the specific answers you're looking for. This guide will walk you through exactly how to use filters in a Looker report, from the basics of adding a simple date range to more advanced techniques for creating interactive dashboards.

Graphed

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.

Build Your First Agent

What Are Looker Filters and Why Do They Matter?

At its core, a filter is simply a rule you apply to a report to narrow down the data being displayed. Instead of looking at all your sales data from the beginning of time across every country, you could use filters to see sales from only the "United States" in the "last 90 days" for a specific "product category."

Using filters effectively is fundamental to good data analysis. Here’s why:

• They Isolate What's Important: Filters cut through the noise. They help you focus on a specific time period, customer segment, marketing channel, or geographic region that is relevant to the question you're asking.
• They Make Reports Interactive: When you add filters to a dashboard, you empower your team to answer their own follow-up questions. A sales manager can easily switch the view from their entire team to a single representative's performance without needing a data analyst to build a new report.
• They Prevent Data Overload: Looking at too much data at once can be overwhelming and often hides the story. By filtering down, you make trends and outliers much easier to spot.
• They Save You Time: Instead of creating dozens of hyper-specific reports (e.g., "Q1 US Sales," "Q2 US Sales," etc.), you can create a single, flexible sales report and use filters to adjust the view as needed.

Think of filters as the interactive controls for your data. They transform static, one-dimensional reports into dynamic tools for exploration.

How to Add and Configure Filters in Looker: A Step-by-Step Guide

Adding a filter to a Looker report is done in the "Explore" view, which is the primary interface for building and modifying reports. Let’s walk through the process, using the example of creating a sales report filtered by date and country.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Step 1: Start in the Explore View

Your journey begins in the Explore interface. This is where you select the dimensions (the "what," like Country, Traffic Source, or Product Name) and the measures (the "how much," like Total Sales, Number of Users, or Conversion Rate) that form the basis of your report. For our example, let's say we've already selected Order Date, Country, and Total Sales to get a basic view of sales over time by country.

Step 2: Locate the Field for Your Filter

On the left-hand side of the Explore view, you’ll see the field picker listing all available dimensions and measures. To add a filter, you first need to find the field you want to filter by. If you want to filter your report to only show data from the last 30 days, you would find the Order Date field. If you wanted to see data for just Canada, you’d look for the Country field.

Step 3: Add the Field to the Filter Pane

Once you've found your desired field, hover your mouse over it. Several icons will appear. Click on the filter icon (it often looks like a small funnel). This action will instantly add the selected field to the "Filters" section at the top of your Explore view. You haven't configured the filter yet, but you've told Looker that this is the field you want to use for your rule.

Step 4: Configure the Filter Condition

This is where you define the specific rule for your filter. In the Filters pane where your field now appears, you'll see a dropdown menu of conditions and a value box. The options available will change depending on the type of data in the field (e.g., text, number, or date).

Common Filter Conditions:

• For Text/String Fields (like Country):
• For Number Fields (like Total Sales):
• For Date Fields (like Order Date):

For our example, you would select is in last for the Order Date filter and type "90 days" into the value box. Then, for the Country filter, you would select is and type "United States" into the value box.

Graphed

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.

Build Your First Agent

Step 5: Click "Run" to Apply the Filter

This is a crucial and often forgotten step. After you configure your filter conditions, Looker won't apply them to your data until you click the Run button in the top right corner. The moment you click it, Looker re-queries your database using your new rules, and the report will update to show only the sales data for the United States over the last 90 days.

Going Beyond Basics: Advanced Looker Filtering Techniques

Once you've mastered the fundamentals, you can start using some of Looker's more powerful filtering capabilities to build truly insightful reports and dashboards.

Using Custom Filters for Complex Logic

Sometimes, the standard filter options aren't enough. What if you want to see data for sales in "California" that are over "$500" OR any sale from "New York," regardless of value? A simple layered filter can't handle this OR logic easily.

This is where Custom Filters come in. Instead of picking from the dropdown menus, you can write your own logical expressions using Looker Functions and Operators.

To create a custom filter, scroll to the bottom of the Filters pane and click "Add Custom Filter." This opens a text editor where you can write an expression like:

${orders.state} = "California" AND ${orders.sale_price} > 500 OR ${orders.state} = "New York"

This simple expression gives you surgical control over your data, allowing for complex multi-condition logic that goes beyond what standard filters can do.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Adding Filters for Interactive Dashboards

One of the most valuable uses for filters is on a dashboard, where a single filter can control multiple reports (or "Tiles") at once. This transforms a static collection of charts into an interactive tool.

To add a dashboard filter:

1. Enter "Edit mode" on your dashboard.
2. Click "Filters" in the toolbar and select "Add Filter."
3. Give your filter a name (e.g., "Date Range") and choose the field it should control (e.g., Order Date).
4. Configure the filter just as you would in the Explore view, setting a default value like "last 30 days."
5. Crucially, go to the "Tiles to Update" tab in the filter configuration. Here, you'll select which reports on your dashboard should adhere to this new filter and specify which field in each report it ties to.

Now, when a user views the dashboard, they can change that one "Date Range" filter, and every connected report will update instantly — no need to edit each report individually.

Best Practices for Effective Filtering

Building filters is easy, but building good filters takes a little thought. Here are a few tips to ensure your reports are useful and easy to interpret.

• Use Defaults Wisely: When adding filters to a dashboard, always set a sensible default value. For a date filter, "last 30 days" is often more useful than an empty value, as it ensures the dashboard loads with relevant, recent data.
• Keep It Simple for Viewers: Don't overwhelm your audience with a dozen different filter options on a dashboard. Focus on the most important and common ways they'll want to segment the data, like date range, campaign, and region.
• Use Relative Dates for Recurring Reports: For any dashboard or report that's viewed on an ongoing basis (e.g., a weekly performance report), use relative date filters like "last 7 days" or "this quarter." This keeps the report relevant without anyone having to manually update the date range each time.
• Label Your Filters Clearly: On a dashboard, the default filter label is the name of the field. This can sometimes be cryptic, like ga_sessions.Region_Name. Change it to something human-readable, like "Region," so users know exactly what it controls.

Final Thoughts

Mastering filters in Looker is the key to unlocking the true power of your data, transforming broad overviews into the sharp financial or operational insights your team needs. By learning how to add, configure, and combine them effectively, you empower yourself and your colleagues to move beyond passive report consumption into active data exploration.

While powerful, building reports and setting up the right filters in tools like Looker still requires a certain level of technical know-how. We built Graphed because we believe getting answers from your data should be as easy as asking a question. Instead of clicking through menus to filter by date, region, and sales value, you can simply ask, "Show me our top-selling products in the US for last quarter," and the platform generates a real-time, interactive chart for you. Graphed handles the complexity of filtering in the background, allowing you to focus on the story your data is telling.