![]() ![]() You can learn more about how to work with the query builder in the “Asking questions” section of the user guide. To do this we’d select “Count of rows” and then add “Source and “Created At.” Then, we’d add a filter to limit the results to just this month. (In the sample dataset that ships with Metabase this would involve using the Source and Created At dimensions of the “People” table.) To do this you’ll need to add two dimensions to your question and use an aggregation that isn’t just “raw data.”Īs an example, we might want to see which service is referring the most people to our product this month. If you’re creating a new question in the query builder, you can also view the result as a multi-series visualization. (At Metabase, we use this to create simple funnel visualizations.) Creating a multi-series visualization in the query builder. While editing a dashboard, click “edit data” on the Number chart of your choice and then select the other saved question(s) you’d like to see represented on the bar chart. To do this, follow the same process outlined above. If you need to compare single numbers and get a sense of how they differ, Metabase also lets you turn multiple Number charts into a bar chart. ![]() You'll see a little warning sign next to SQL questions to indicate this and when you try adding them just be aware it may not work. Metabase has less information about SQL based questions, so we cannot guarantee if they can be added reliably. Depending on how dense your data is, at this point you might want to consider enlarging your chart to make sure the data is legible. Once you have your chart looking how you’d like, hit done and your changes will be shown on the card in the dashboard. To remove a series either uncheck the box, or click the x next to the title in the legend above the chart. Repeat this process as many times as you need. The X and Y axis will automatically update if necessary and Metabase will create a legend using the existing card titles to help you understand which question maps to which series on the chart. Check the box next to any questions you’d like to see side-by-side with the original, and Metabase will add it to the same chart. In the Edit Data modal you’ll see the original question, and on the right you’ll see a list of compatible questions you can choose from.Click this button to start adding series that you want to compare to the first series. While in edit mode on the dashboard, hovering on the card will show a “Edit data” button. In practice, these will usually be line charts or bar charts. Here’s how:Īdd a question with a dimension like time or a category to a dashboard. If you already have two or more saved questions you’d like to compare, and they share a dimension, they can be combined on any dashboard. Asking a question that involves multiple dimensions in the query builder (or in SQL if you’re fancy).Į.g. ![]() Let me see revenue over time and cost over time together. ![]() Combining two existing saved questions that share a common dimension (like time) on a dashboardĮ.g.In Metabase there are two main ways to get data side-by-side. Orders per day from a few different product lines.Average order price this month and user signups for that month.Here are just a few examples of data that is better together than apart. One of the best ways to add context and clarity when communicating with data is to show data side-by-side with other data. Data in isolation is rarely all that useful. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |