We’ll click the Pick the metric you want to see button in the Summarize step and select Count of rows. The metric in this case the number (or count) of orders after we’ve filtered for orders greater than $40. When we ask things like “how many,” “what’s the total,” “what’s the average,” etc., we’re talking about summarizing our data. To close the preview, you can click on the X in the upper right of the preview. Previewing the results after adding a filter.Īs expected, we can see in figure 5 that all of the subtotals are over $40 after the filter has been applied. With each step, you can click on the triangle on the right to preview the results so far. In the dropdown menu, change “Equal to” to “Greater than”, enter 40 in the input field, then click Add filter.
In the Filter step, we’ll click the purple Add filters to narrow your answer button, and we’ll select Subtotal as the column to filter on. Filtering the Orders table by the Subtotal field. To find out, we want to filter the data by the field we’re interested in, which in this case is the Subtotal. More precisely, this question translates to: “How many records (or rows) are in the Orders table that have a value greater than 40 in the Subtotal column?” How many orders have been placed with a subtotal (before tax) greater than $40? The Orders table has a bunch of fake data in it about product orders from a made-up company. The query builder with the Orders table added to the Data step. You can start a new question from:įor now, let’s start from Raw data > Sample database > Orders. But we’re getting ahead of ourselves for the next few examples, we’ll be using the Sample Database that comes with Metabase.Ĭlick on + New in the main nav, and select Question. You can play around with a question by filtering and summarizing its results, save those explorations as new questions, and add questions to dashboards. Questions have titles, IDs, and unique URLs you can copy and share with others. Asking a new questionĪ question in Metabase is a query, the results of that query, and the visualization and formatting of those results (even if that visualization is just a table). The Browse Data section will show you the databases connected to your Metabase, including the Sample Database that ships with Metabase. To open and close the navigation sidebar, click on the Metabase logo in the upper left. You can also Bookmark your favorite items, and they’ll appear toward the top of the navigation sidebar. Settings (the gear icon at the bottom of the navigation sidebar).Data section, which lists all of the data sources your Metabase is connected to.You have your own personal collection to store drafts and experiments that aren’t yet ready to share. Collections, where you’ll store all of your questions, dashboards, and models.Home button to return to your Metabase home page.Some automatic explorations of your tables that you can look at and save as dashboard.The home page of Metabase before anyone has added items to the Our Analytics collection.įresh out of the box, Metabase will show you a few things on the home page: If your Metabase isn’t up and running yet, check out:
0 kommentar(er)
