Metabase lets you link filters on dashboards so that the value plugged into one filter limits the options available to the linked filters.
My Udemy Course: Build a Full-Stack Chrome Extension with NodeJS and MongoDB: https://www.udemy.com/course/build-a-full-stack-chrome-extension-with-nodejs-an. Let’s start with a simple question written in SQL that shows the orders per month from the Sample Dataset included with Metabase. From any Metabase page, in the upper right on the navigation bar, click on the Write SQL icon to visit the native query editor. A question written in SQL showing orders per month, visualized as a line chart. From your dashboard, click on the pencil icon to enter dashboard edit mode. Hover over the card containing the question you want to customize. Metabase will display a menu at the top right of the card. Select the Click behavior option (the icon with the mouse cursor clicking on a card). In the Sample Dataset that ships with Metabase, you would group by the Source and Created At columns of the People table. To create the multi-series chart, select the People table, click on the Summarize button in the upper right, then add Source and Created At as groupings (the count of rows metric that we want is selected by default). Metabase This is a simple Flask Application that embeds Metabase dashboards. This allows us to easily restrict access to individual dashboards to specific users in addition to adding the data download button only seen when dashboards are embedded.
Let’s walk through an example using the Sample Dataset included with Metabase. We’ll start with a dashboard on orders data that includes a single filter for state:
Let’s take a quick look under the hood so you can see how we’ve set up our State filter. Here’s our dashboard in Edit mode:
Metabase Free
We’ve connected our State filter to each card on the dashboard. One thing to call out is that we can connect the State filter to multiple different state columns, and it just works. In this dashboard, we’ve connected the State filter to most cards by filtering on the column User.State, except for the People map card, which filters on Person.State. If we plug a value into the State filter, say WI for Wisconsin, the dashboard will update all the cards to display only the orders placed by people who live in the state of Wisconsin:
To link filters, we’re going to need another filter. So let’s say we want to add a filter to the dashboard for cities. On the dashboard, we’ll click on the pencil icon to enter dashboard edit mode, then click on the filter icon to add a new filter.
For What do you want to filter?, we’ll select Location. For What kind of filter?, we’ll select City. Google drive for mac app.
With our City filter created, we can now wire it up by connecting each card to the filter. To do that, we select which column we want to filter by, which in our case is Person.City or User.City, depending on the card.
Once we’ve connected our cards to the new City filter, we’ll Save our changes.
And here’s where we’ll run into an issue. Right now, the filters are independent of each other. So the State filter will let us pick a state, say Wisconsin, and the City filter will let us select any city - including cities outside of Wisconsin. Basically, this dashboard will let us set up nonsensical filter combinations, like filtering for the city of Austin in the state of Wisconsin, which is not how our universe is currently set up. As expected, this combo of filters yields no results:
We can prevent people from creating these nonsensical filter combos by linking the filters. For example, if someone chooses Wisconsin in the State filter, the City filter should “know” to limit the options for cities to only those within the state of Wisconsin.
To link the two filters, we’ll click on the pencil icon to return to dashboard edit mode. Since we want the City filter to react to a change in the State filter, we’ll want to change the settings on the City filter. We’ll click the gears icon on the City filter to bring up the settings sidebar for the City filter.
Here’s the important part: in the sidebar, we’ll click on the Linked filters tab, which presents us with options to limit this filter’s choices, i.e., the City filter’s choices.
Metabase will list the available filters that we can link the City filter to (figure 7). In this case, there’s only one filter, the State filter, so we’ll toggle that filter to “on” to link the filter.
Let’s Save our changes, and try it out.
With the City filter linked to the State filter, when we plug in WI for the state filter, we’ll see that the City filter now knows to only show cities in Wisconsin.
Further reading
Here are some more articles that cover working with filters:
Scan mac for issues. You can also check out our documentation on Dashboard Filters.
Google uses cookies and data to:- Deliver and maintain services, like tracking outages and protecting against spam, fraud, and abuse
- Measure audience engagement and site statistics to understand how our services are used
Metabase Sample Dashboard Report
If you agree, we’ll also use cookies and data to:- Improve the quality of our services and develop new ones
- Deliver and measure the effectiveness of ads
- Show personalized content, depending on your settings
- Show personalized or generic ads, depending on your settings, on Google and across the web
Metabase Pricing
Click “Customize” to review options, including controls to reject the use of cookies for personalization and information about browser-level controls to reject some or all cookies for other uses. You can also visit g.co/privacytools anytime.