hostbulk.blogg.se - Metabase filters

If a filter that used to work no longer seems to, or seems to eliminate all of the rows: Root cause: Someone has changed the database schema, e.g., renamed or deleted a column in a table. Has someone renamed or deleted columns in the database? If you created the question in SQL, then you only get a dropdown if the filter is a Field Filter and the Filtering on this field option is set to your preferred input type: A list of all values (dropdown list) and the number of unique values is less than 100. Click the button Re-scan this field in the bottom.Set Field Type to "Category" and Filtering on this field to "A list of all values.".Click the gear-icon to view all the field's settings.Select the database, schema, table, and field in question.Go to the Admin Panel and select the Data Model tab.However, if the number of unique categories exceeds 100 values, Metabase will display a search box with autocomplete instead of a dropdown. Root cause: Metabase only displays a dropdown list of possible values for a variable if it knows that the field in question is a category rather than (for example) an arbitrary number or arbitrary text. Are you seeing a different kind of input widget than you expected?įor example, you want a dropdown but you're seeing a search box or a text input box. So you can add a dashboard filter and refer to columns in the question's results without creating variables explicitly. If you built your question in the Query Builder, Metabase knows which columns you're using, and which columns you can connect to different types of filters.

If these steps don’t fix your error, go to Troubleshooting SQL variables.

These can be plain variables, or Field Filters, with names enclosed in double curly braces, typically in a WHERE clause.

Check that your SQL query contains at least one variable for the filter to insert the value.

Root cause: If your SQL question doesn't contain a variable, the filter can't insert the value into the query to filter the results. If the card you're trying to filter is written in SQL, does its SQL query contain a variable?

Check that the filter widget is connected to the column you want to filter on each relevant card.

If no columns are available to select on that card, you may need to change the filter type, from say a text filter to a date filter, to connect the filter to the card.

Check that each card you want to wire up to the filter has a column selected. In dashboard edit mode, click on the gear icon next to the filter.Root cause: The filter isn't connected to any cards on the dashboard, or connected to the wrong field. Is the dashboard filter actually connected to your question? If you're using a SQL variable with the variable type "field filter", go to Troubleshooting SQL variables. If you've created a linked filter, please see this troubleshooting guide instead. the filter removes all of the rows from the table no matter what value you set it to.the filter doesn't show a dropdown list of possible values when you use it, or.the question you want to connect the filter to doesn't show up, or.You've tried to add a filter widget to your dashboard, but: