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: 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: If you are interested, ByWater Solutions offers hosting and support for the Open Source edition of Metabase.Metabase’s two core concepts are questions and their corresponding answers. Here is an example of our partners at McKinney Public Library who are displaying the statistics in their public dashboard from Metabase. You can think of dashboards as shareable reports that feature a set of related questions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |