![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |