In this case, state is the parent filter, and city is the child filter. You can link the city filter to the state filter so that when someone filters by California, the city filter will “know” to only show cities in California. Say you have two filters, one to filter by state, the other to filter by city. You can also link filters so that a child filter knows to limit its choices based on the activation of a parent filter. To override the default text box or search box filter widget, ask your Metabase admin to help you update the column’s settings on the Data Model page. In both cases, you can pick one or multiple selections for your filter. ![]() If the column you’re using for a filter has more than 100 unique values, you’ll automatically see a search box with autocomplete suggestions.Ĭolumns with fewer than 100 distinct values will list all options: You can also set up a dashboard question to update a filter on click. To stop filtering, just click the blue X. Once you’ve added a filter to your dashboard, just click on the filter to select a value and activate the filter. You can specify where the values should come from: To change the selectable values in a filter: click on the gear icon for that filter, and under “How should users filter on this column”, click on the Dropdown list, then click Edit.Under the Settings tab, enter a value in the Default value input field. To set a default value: click on the filter’s gear icon to open the filter sidebar.To reorder your filters: click on the grabber handle on the left side of a filter, then drag the filter to a different position.If you accidentally remove a filter, just click Cancel in the top-right to exit dashboard editing mode without saving your changes. Under the Settings tab, click Remove in the sidebar. To remove a filter: click on the filter’s gear icon to open the filter sidebar.You can wire up individual cards to the filter, and use the sidebar to update the label. To edit a filter: click the pencil icon to enter dashboard editing mode, then click the gear icon button on the filter you want to change.Here we’ve wired up a Text filter to a card on the field:īefore we Save our changes, we can edit our filter’s settings. If there’s a card on your dashboard that you don’t want to use with the filter, or that doesn’t make sense to use with the filter, that’s okay - the filter will only be applied to the cards you select. The sidebar on the right displays the settings for the current filter. Each card will feature a dropdown menu where you can select the column to filter. Metabase will display a filter editing sidebar where you can wire up your new filter to each applicable card. We’ll select a Text or Category filter, and then select the Is option to select one or more values from a list. Let’s add a filter widget to our dashboard. For an in-depth article on this, check out Adding filters to dashboards with SQL questions. If you’re trying to filter native/SQL questions, you’ll need to add a bit of additional markup to your query in order to use a dashboard filter with that question. Match values that end with the entered text.įiltering dashboards with native/SQL questions Match values that begin with the entered text. Filter out values that contain the entered text. Match values that contain the entered text. Select one or more values from a list or search box. Number filterĪ flexible filter type that will let you create either a dropdown menu or an input box to filter on any category field in your cards. The ID filter provides a simple input box where you can type the ID of a user, order, etc. There are four types of Location filters to choose from: To get a widget that’s just like the time filter in the query builder, choose All options. Single Date and Date Range will provide a calendar widget, while the other options all provide slightly different dropdown interfaces for picking values. When picking a Time filter, Metabase will prompt you to pick a specific type of filter widget: ![]() The type of filter you choose will determine what the filter widget will look like, as well as which fields you’ll be able to filter your cards by: Time filters You can choose from a number of filter types: To add a filter to a dashboard, first click the pencil icon to enter dashboard editing mode, then click the Add a Filter button that appears in the top-right. Instead of creating duplicate dashboards, you can add filter widgets to let people change variables for cards on a dashboard. ![]() Have you ever found yourself in a situation where it seems like you need to create nearly identical copies of the same dashboard, with just one different variable? Maybe you have an Earnings dashboard, but you want to see the data for each city your business is in, or maybe you have a KPI dashboard that you want to see broken out by month.
0 Comments
Leave a Reply. |