Jun 20, 2016 in Using Metabase

3 min read

Unfiltered Filter Excitement

Maz Ameli Portrait
Maz Ameli
‧ Jun 20, 2016 in Using Metabase

‧ 3 min read

Share this article

One feature we’re especially excited to be including in the latest version of Metabase is dashboard-wide filters. If you’ve been using Metabase since the early days, then you are a cool person who probably knows where to find the best sushi and whatnot. But also, while you know that Metabase is a great way to easily ask questions about your data and to create great-looking dashboards and reports, one thing that hasn’t been so easy in Metabase is easily modifying all the cards on a dashboard.

For example, if you wanted to see the same set of charts or metrics, but broken out in different ways (like by Date, Customer, or Category), then you had to recreate that dashboard over and over with slight tweaks to the cards.

Dashboard filters fix this.

Creating Dashboard Filters

This is easier shown than told, so let’s take a look at this example Orders dashboard for a fictional company that builds widgets, doohickeys, gizmos, and the like.

Dashboard

This dashboard has a bunch of interesting charts and data on it, but it’s showing us data for all time. In the old days, if we wanted to see this same dashboard with only data from, say, June of 2016, we’d have to edit all of the questions, which would be tedious.

Instead, we can add a Month and Year filter to this dashboard. First, we’ll start editing the dashboard, and then click the new Add a Filter button, and select Time, then Month and Year.

Add a filter

Add time filter

Add month filter

Next, for each card on the dashboard, we just need to pick which field to do the filtering on.

Map cards

In this example, we’re interested in filtering the whole dashboard by when orders were created, so we’re selecting the “Created At” field for each of our cards. Then we’ll click Done, then Save.

Cards mapped

Now we can click on our new Month and Year filter and select a specific month…

Month dropdown

…and all the cards on our dashboard change!

Filtering by month

Different Kinds of Filters

Time isn’t the only thing we can filter on, though. Let’s say we want to be able to see how our different product categories are performing — are widgets selling better than gizmos? Instead of creating a new dashboard with the same charts, but with different product categories, we can just add a category filter.

So we’ll go edit the dashboard again, add a new filter, and select Other Categories. This is a flexible option that will let us filter on basically anything that’s not a date, location, or ID.

Category filter

Next let’s select the product “Category” field for all the cards, then click Done and Save again…

Category filter mapped

…and now we have two filters, which we can use independently or together. Huzzah!

Using both filters

Try it Yourself!

Our hope is that these new filters will make it really easy for even your least-sophisticated teammates to start exploring your data. Give it a look and let us know what you think! We’re @metabase on Twitter. And if you don’t have the latest version of Metabase yet, you can download it here.

xoxo Metabase

You might also enjoy

All posts
Set up a basic pipeline for log analysis Image Mar 04, 2024 in Using Metabase

Set up a basic pipeline for log analysis

You can use a BI tool for small scale log analysis with data visualizations. Here are a few tips and suggestions to get started.

The Metabase Team Portrait
The Metabase Team

4 min read

Embed a Metabase dashboard in Zendesk Image Feb 26, 2024 in Using Metabase

Embed a Metabase dashboard in Zendesk

Get the customer data and insights you need automatically filtered and ready for use within your support tickets. You can also embed a dashboard in Salesforce, Stripe, Jira, or platforms that allow embedding URLs.

Ignacio Beines Furcada and Sarina Bloodgood Portrait
Ignacio Beines Furcada and Sarina Bloodgood

5 min read

All posts
Close Form Button

Subscribe to our newsletter

Stay in touch with updates and news from Metabase. No spam, ever.