![]() ![]() ![]() What this means in practice is that you can do things like use complex SQL queries to create new tables that can be used in a question just like any other table in your database. If you've (06-sharing-answers.html), in the Data menu you'll see the option to use one of your saved questions as source data. The first dropdown menu in the question builder is where you’ll choose the database and table you want. This means that when you’re thinking about how to phrase your question, you’ll need to decide what your question is about, and which table has that information in it. For example, in a Customers table, each row in the table would represent a single customer. Typically, tables will be named for the thing that each row in the table contains. **Groupings**, where you can group or break out your metric by time, location, or other categoriesĪll of the data in databases are in tables. **View**, where you choose what you want to see - raw table data, a basic metric, or a saved metric **Filters**, where you can optionally add one or more filters to narrow down your source data **Data**, where you pick the source data you want to ask a question about The question builder is made up of four distinct sections, from left to right: Metabase has a simple graphical question builder that looks like this: ![]() If your team hasn't set up any metrics or segments, or if you have a question that isn't covered by an existing question or segment, you can create a custom question using the Question Builder interface by clicking "Custom." Or, if you're an advanced user, you can click "SQL" to go straight to the SQL/native query editor. ![]() You can also use the Action Menu when viewing a segment or table to see any metrics that are related, or to summarize the table. When viewing a segment or a table, you can click on the headings of columns to see options for ways to explore more, like seeing the distribution of the values a column has, or the number of distinct values: When you click on one, you'll see a list, like this one: Selecting the Segment option from the new question menu will show you a list of your company's segments. # Asking a new question about a segmentĪ **segment** is any kind of list or table of things that your company cares about: returning users, orders that used a certain promo code, or sales leads that need to be followed up with are all examples of possible segments. You can also use the Action Menu in the bottom-right of the screen to choose a break out, or to see the table data that the metric uses: From there, you can click directly on the number to break it out in interesting ways - like by day, by state, by customer, etc.: !(images/metrics-list.png)Ĭlicking on a metric will show you that number. Clicking on the metric option will show you a list of your company's metrics: So if you have a question like, "how many users have we had in the last 30 days?", then you could start by finding a metric like "Total Users" from your company's list of metrics, and then filtering it down to the time period you care about. # Asking a new question about a metricĪ **metric** is a numeric measurement of something your company wants to track, like revenue, the total number of users, or the number of events that have occurred. from scratch with the Question Builder interfaceĪsking a new question about a **metric** or a **segment** is often a great place to start. If an administrator has (./administration-guide/07-segments-and-metrics.md), when you click on the New Question button, you'll see a screen like this one: To ask Metabase a question, click the New Question button at the top of the screen. Everything else is based around questions and answers. Metabase's two core concepts are questions and their corresponding answers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |