One important thing to understand when filtering on a date column is the difference between specific and relative dates: Any filters you apply here will show up in the notebook editor, and vice versa. To remove all the filters you’ve applied, click on Clear all filters in the bottom left of the filter modal.
#Metabase query builder update
When you’re done adding filters, hit Apply filters to rerun the query and update its results. Any tables linked by foreign keys will be displayed in the left tab of the modal. Filter options will differ depending on the field type. Here you can add multiple filters to your question in one go. When viewing a table or chart, clicking on the Filter will bring up the filter modal: Date columns give you a lot of options to filter by specific date ranges, relative date ranges, and more.Text or category columns let you specify that you only want to include data where this column is or isn’t a specific option, or you can exclude empty cells in that column.Numeric columns let you add filters to only include rows in your table where this number is between two specific values, or is greater or less than a specific value, or is exactly equal to something.Filter typesīroadly speaking, there are three types of columns, each with their own set of filtering options: If you click on the X, you’ll remove your filter. If you want to edit your filter, just click the little purple filter at the top of the screen. Your data will be updated with the filter applied. Once you’re happy with your filter, click Add filter, and visualize your results. (This is basically like a SQL HAVING clause.) This lets you do things like summarize by the count of rows per month, and then add a filter on the count column to only include rows where the count is greater than 100. You can add subsequent filter steps after each summarize step. Depending on the data type of the column you pick, you’ll get different filter types, like a calendar for date columns. When you add a filter step, you can select one or more columns to filter on. Maybe you only want to see olive-colored pants, or books where the author’s last name is “Borges,” or pictures of people wearing olive-colored pants reading Jorge Luis Borges. You’re probably already familiar with filtering when looking for something online, like when shopping. Filteringįiltering just means narrowing things down based on certain criteria. You can also select multiple tables from the same database by joining them.
You can click on a table to select which columns you want to include in your results. Here you’ll pick a model, a table from a database, or a saved question. The data section is where you select the data you want to work with. To the right of completed step is a Preview button (looks like a Play button - a triangle pointing to the right) that shows you the first 10 rows of the results of your question up to that step. This is the query builder’s notebook editor. Say you selected Raw data > Sample database > Orders, then you’ll see something like this: Once you select your data, Metabase will take you the query builder. Questions that have columns that are named the same or similar thing, like Count and Count 2.Questions that use Cumulative Sum or Cumulative Count aggregations.Note that there are some kinds of saved questions that can’t be used as source data: You can use the results of any question as the starting point for a new question. You’ll need to specify the database and the table in that database as the starting point for your question. Sometimes these are called derived tables, as they usually pull together data from multiple raw tables. A model is a special kind of saved question meant to be used as a good starting point for questions. Creating a new question with the query builderįrom the + New dropdown, select Question, then pick your starting data:
#Metabase query builder how to
This page covers how to ask a question using Metabase’s graphical query builder, the “Question” option. To ask a question in Metabase, click the + New button in the upper right of the main navigation bar, and select either:
Metabase’s two core concepts are questions and their corresponding answers.
0 kommentar(er)
