The input box is the default filter widget for columns with more than 100 unique values. Useful for looking up partial matches (such as the “contains” filter) in columns that contain free text, such as comments or descriptions. Plain input boxĪn input box that lets people enter plain text (no suggestion list). It’s is the default filter widget for columns with less than 100 unique values. The search box is a good choice for most columns containing labels, categories, statuses, and so on. The suggestion list will display checkboxes for multi-select filters. SQL model: go to your model’s metadata settings, find your column, and set the Database column this maps to.Ī search box that suggests a list of matching filter values as you type.Table or GUI model: an admin will need to enable the dropdown widget for that column from Metabase’s Admin settings.If you’re not seeing the Dropdown list option, and your dashboard filter is based on a column from a: You should choose the dropdown widget if you want the list of filter values to load instantly (from cache). People can use checkboxes to select more than one value on multi-select filters. From the filter settings sidebar, set How should people filter on this column?:Ī list of all of the possible values in a column.Renaming the filter only affects the filter’s display the label has no effect on which columns Metabase filters. In dashboard edit mode, click your filter’s gear icon.Click the gear icon on the filter you want to edit.įrom this filter editing view, you can wire up dashboard cards to the filter, or use the filter settings sidebar to:.You can even wire up filters to text cards, but only if the text card includes a variable. Wiring up dashboard filters to text cards For an in-depth article, check out Adding filters to dashboards with SQL questions. If you’re trying to connect a filter to a card with a native/SQL questions, you’ll need to add a variable or field filter to your query. Filtering dashboards with native/SQL questions To undo this auto-connecting of cards, click on the toast that pops up when Metabase auto-connects the cards, or manually disconnect the cards by clicking on the “X” next to the connected field. If you later add a card with the selected field, Metabase will also try to connect that filter to the new card. If there are other cards that also have the field you select, Metabase will automatically connect the filter to those cards too (including cards on other tabs). Here we’ve wired up a Text filter to the “Event types” card, telling Metabase that the column to filter on should be the field: Match values that end with the entered text.ĭashboard filters apply across all dashboard tabs, though for each filter you add, you’ll need to tell Metabase which column the filter should update for each card.Ĭlick on a card’s dropdown menu to select the field that you want the widget to filter on. Match values that begin with the entered text. Filter out values that contain the entered text. Match values that contain the entered text. For multiple values, the card must be either a question built using the query builder, or a native/SQL question using a field filter. Use Is when you just want to plug a value into a variable. 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 how the filter works, 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: Connect your filter to one or more dashboard cards.Click the filter icon that appears in the top-right to add a filter.Click the pencil icon to enter dashboard editing mode.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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |