How to Create a Dynamic Dashboard in Looker with AI

Building a Looker dashboard that just sits there, showing the same static numbers every day, can feel like a missed opportunity. While it's technically accurate, it doesn't invite questions or lead to new insights. The real power is unlocked when you transform that static report into a dynamic, interactive tool your whole team can use to explore data on their own. This guide will walk you through the essential steps to make your Looker dashboards truly dynamic using powerful features like filters, parameters, and drill-downs.

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 Exactly Makes a Looker Dashboard "Dynamic"?

On the surface, a "dynamic" dashboard simply means it's interactive. Instead of looking at a fixed image of your data, users can actively engage with it. But a great dynamic dashboard is more than just a few clickable buttons, it's a living tool that empowers your team to be more data-driven. A static report answers one question. A dynamic dashboard answers the first question, and then the next ten follow-up questions that come to mind.

Here's what that looks like in practice:

• User-Controlled Filters: Users can slice and dice the data themselves by selecting different date ranges, regions, product categories, or marketing channels without having to request a new report.
• "What-If" Scenarios: By using parameters, you can build dashboards that let users input their own variables - like a projected sales growth percentage or an ad budget - to instantly see the potential impact.
• Drill-Downs: When a user sees a high-level number or anomaly, they can click into the visualization to see the underlying data that makes up that number, moving from a country-level view down to a specific state or even an individual transaction.
• Real-Time Data: The data isn't a stale CSV export from last week. A dynamic dashboard is connected directly to your database, so the insights are always based on the latest information.

The Foundation: Creating a Basic Looker Dashboard

Before you can make a dashboard dynamic, you need a dashboard. If you're new to Looker, here's a quick-start guide to getting your first dashboard and its "Tiles" (Looker's term for individual reports or visualizations) set up.

First, navigate to the folder where you want your dashboard to live. In the top right, click New and select Dashboard. Give it a descriptive name like "Q3 Marketing Performance" and click Create Dashboard.

Now you have a blank canvas. To add your first visualization (Tile):

1. Click Edit dashboard in the top right corner.
2. Click Add and select Visualization. This will take you to the Explore interface, which is where you build your individual analyses.
3. For example, let's create a report showing "Revenue by Traffic Source." In the Explore, you'd select a "Traffic Source" dimension and a "Total Revenue" measure.
4. Choose your preferred visualization type (e.g., a Bar Chart or a Pie Chart).
5. Once you're happy with it, click the gear icon in the top right and select Save to Dashboard.
6. Choose the dashboard you just created, give the Tile a name, and click Save.

Repeat this process for a few more key metrics you want to track, like "Sessions Over Time" or "Conversion Rate by Landing Page." After saving your changes, you'll have a very basic, static dashboard. Now, let's make it interactive.

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

Level Up: Adding Dynamic Filters

Filters are the most common and effective way to make a dashboard dynamic. They turn your dashboard from a monologue into a conversation, allowing users to ask, "Okay, but what if we only look at sales from last month?" or "How did this look for just our European market?"

Let's add a "Date Range" filter to our dashboard so users can look at different time periods.

Step 1: Add a Filter to the Dashboard

With your dashboard in Edit mode, click Filters at the top of the page, then click Add Filter. A new configuration window will pop up.

• Title: Give the filter a clear, user-friendly name. Let's call it "Date Range."
• Control: Choose the type of filter control you want. For a date range, "Date Range" is perfect. Looker offers many others, like dropdown menus, sliders, and text fields for different use cases.
• Default Value: Set a default time period, like "is in the past 90 days." This ensures the dashboard always loads with relevant data.

Step 2: Connect the Filter to Your Tiles

This is the most critical part. Creating the filter widget is easy, but you have to tell each Tile how to react to it. In the filter configuration window, you'll see a tab called Tiles To Update. Here, you'll see a list of every Tile on your dashboard.

1. For your "Revenue by Traffic Source" Tile, you need to tell Looker which field in that Tile's data should be filtered by the "Date Range."
2. In the dropdown next to the Tile name, find and select your date dimension. It might be called "Order Date," "Creation Date," or "Event Date."
3. Repeat this for every other Tile on the dashboard that needs to be affected by this date filter. If you have a Tile that should not change with the date (like an "All-Time Total Revenue" KPI), simply leave it unlinked.

Click Add and then Save your dashboard. You will now see a "Date Range" filter at the top of your dashboard. Any user can click on it, select a new time frame, click Update, and watch as all the connected visualizations refresh instantly to reflect their selection.

You can repeat this process to add more filters for things like "Sales Region," "Device Type," or "Marketing Campaign," giving your users precise control over the data they see.

Advanced Dynamics: Using Parameters for "What-If" Analysis

While filters let you view existing data from different angles, parameters allow you to inject hypothetical variables into your analysis. This transforms your dashboard from a reporting tool into a forecasting and planning tool. It's perfect for answering speculative questions like, "What would our projected revenue look like if we hit a 15% growth rate?"

This process is more advanced as it requires a little bit of LookML (Looker's modeling language). But the payoff is huge.

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 1: Create a Parameter in LookML

Go into your Looker project's LookML and find the appropriate view file. Let's create a parameter that lets a user input a percentage growth rate. The code would look something like this:

parameter: sales_growth_forecast {
  type: number
  label: "Sales Growth %"
}

This creates a new "parameter" named sales_growth_forecast that users can interact with.

Step 2: Use the Parameter in a Measure

Now, we'll create a new measure that uses the input from this parameter. In the same view file, you could create a "Projected Revenue" measure like this:

measure: projected_revenue {
  type: sum
  sql: ${TABLE}.revenue * (1 + {% parameter sales_growth_forecast %} / 100.0) ,,
  value_format_name: usd
}

This measure takes the actual revenue and multiplies it by the growth rate the user inputs through the parameter. The {% parameter ... %} syntax is how you reference a user's input within LookML.

Step 3: Add the Parameter Filter to Your Dashboard

After saving your LookML changes, go back to your dashboard in Edit mode. Add a new Filter just as you did before. This time, when you go to choose the Field to Filter for a Tile, select the new parameter you created: "Sales Growth %".

Save everything. Now, users will have a field on their dashboard where they can type in a number (like 10 or 25). Any charts using your new "Projected Revenue" measure will update in real-time, showing them a "what-if" forecast. This is one of the most powerful "AI-like" features you can build in Looker because it feels like the dashboard is intelligently responding to user speculation.

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

Uncover Insights with Drill-Downs

Sometimes the most important view isn't the one on the dashboard, but the specific data hiding behind a single number. Drill-downs are how you uncover those granular insights. Looker makes this highly interactive without requiring filters.

By default, when you click on part of a chart in Looker, it shows you the raw data behind it. But you can make this experience much richer by defining custom drill paths in your LookML.

For example, if you have a dimension called country, you can define a drill path so when a user clicks on a country, they see the data for that country broken down by state and then city.

The LookML looks like this:

dimension: country {
  type: string
  sql: ${TABLE}.country ,,
  drill_fields: [state, city]
}

With this simple line of code, your users can now naturally explore geographic data just by clicking. They can see a total for the United States, click on it to see which states contributed the most, and click again on California to see the breakdown by city. This creates an intuitive and discovery-driven experience that encourages deeper analysis.

Final Thoughts

Building a dynamic dashboard in Looker is about shifting your mindset - from creating static visuals to delivering an interactive exploration tool. By leveraging features like filters for slicing data, parameters for what-if scenarios, and drill-downs for deep analysis, you can empower your team to get answers for themselves and make smarter, more informed decisions.

While Looker is incredibly powerful, you can see that getting these dynamic features working requires a healthy amount of setup, clicking through configuration menus, and often writing some LookML code. We've been there ourselves and felt the friction of spending hours setting up reports instead of finding insights. That's why we created Graphed. After a one-click connection to your data sources, you can create a dynamic dashboard simply by describing what you want to see in plain English. For example, asking "create a dashboard showing Shopify revenue versus Facebook Ads spend by campaign for the past 90 days" instantly builds an interactive report, complete with all the filters you need, in seconds - no manual configuration or coding required.