Menu Close

Unfiltered Filter Excitement

Jun 20, 2016 by Maz Ameli

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