Learn how to refer to a saved question in a SQL query. Next: Referencing saved questions in queries Field Filters: create smart filter widgets for SQL questions.Create filter widgets for charts using SQL variables. So if you are trying to use one of the other Time options on the dashboard, you’ll need to change the variable to a Field Filter variable and map it to a date column. If you add a Date variable to the question, then it’s only possible to use the dashboard filter option Single Date. In this example, you’d create a new dashboard (or go to an existing dashboard), click the Pencil icon to enter Dashboard edit mode, add the SQL question that contains your State Field Filter variable, add a new dashboard filter (or edit an existing Location filter), then click the dropdown on the SQL question card to see the State Field Filter. To make a clause optional in your native query, type [[brackets around a and you map it to a State field, you can map a Location dashboard filter to your SQL question. Metabase cho php chng ta t cu hi v d liu v hin th cu tr li di nhiu dng biu khc nhau, thun tin cho vic c v x l thng tin. For example, you can create an optional WHERE clause that contains a SQL variable, so that if no value is supplied to the variable (either in the filter or via the URL), the query will still run as if there were no WHERE clause. Metabase l cng c m ngun m h tr phn tch d liu v chia s chng mt cch d dng. You can make a clause optional in a query. When you have multiple filter widgets, you can click on a filter widget and drag it around to rearrange the order. You can include multiple variables in the query, and Metabase will add multiple filter widgets to the question. That last variable type, Field Filter, is special it lets you create “smart” filter widgets, like a search box, or a dropdown menu of values, or a dynamic date picker that allows you to specify a date range. Metabase MongoDB - join collections across databases - Stack Overflow Metabase MongoDB - join collections across databases Ask Question Asked 6 months ago Modified 6 months ago Viewed 129 times 0 Is there any way or hack to join two (or more) collections from different dbs together in Metabase's native questions e.g. Field Filter: different filter widgets, depending on the mapped field.If you want a more expressive date picker, like specifying a range, you’ll want to use a Field Filter. You can set a type for a variable, which changes the kind of filter widget that Metabase presents. When you define a variable, the Variables side panel will appear.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |