You could specify a specific productID when embedding the question. SQL based questions with template variables can also accept parameters for each variable. For example, if you have a dashboard with a filter on Publisher ID, this can be specified as a parameter when embedding, so that you could insert the dashboard filtered down to a specific Publisher ID. In dashboards, these are synonymous with dashboard filters. Some dashboards and questions have the ability to accept parameters. The charts and dashboards you will be embedding live in the Metabase application, and will be embedded in your application (i.e. Key Concepts ApplicationsĪn important distinction to keep in mind is the difference between Metabase and the embedding application. You can even pass parameters to these embeds to customize them for different users. It may take some back-and-forth to figure out which display settings are right for your data, so try a few different options to see what works best for you and your team.Metabase includes a powerful application embedding feature that allows you to embed your saved questions or dashboards in your own web applications. Here’s that example displayed in three different bar chart styles: Fig. Let’s say we wanted to see how many orders were placed per product category across different quarters of a year. To create a stacked bar chart, click on Settings > Display and select either Stack or Stack - 100%. A 100% stacked bar chart is similar, but displays those parts as relative percentages, so every bar spans the full y-axis. If the data we’re visualizing can be broken down into multiple categories within a whole, we could consider using a stacked bar chart. Here we can hide or customize axes labels. Select the Labels button in the Settings sidebar. The options for the y-axis are hide and show, while the x-axis has several more: With the Show lines and marks options we can change the way the categories and quantities are represented on each axis. The linear option is selected automatically, and for our example provides the most accurate representation of our data, so we’ll keep it. Here we can specify how we want our table organized. We can also set the display to a stacked bar chart, which we’ll get into in a bit. Toggling on Show values places the count values above each column.Ĭlicking the color swatch at the bottom of the sidebar will open a color palette to set the bar color. Adding a goal line for our arbitrary sales goal.' In figure 3, we add a goal line at 5500 and name it Arbitrary Sales Goal. In the Settings > Display section, we can add a goal line that specifies where we want the values to be and Metabase can alert us when the values exceed (or drop below) that goal. Bar chart settingsĬlick on the Settings button at the bottom left of the chart to see all our tools: Notebook of question that summarizes the count of orders grouped by product category.Ĭlick Visualize, and Metabase will present the data as a bar chart: Fig. Next, summarize the count of rows and group by Product -> Category. Choose the Sample Database’s Orders table as your data. Select + New > Question > Raw data > Sample database. You can follow along using Metabase’s Sample Database. We’ll walk through creating a bar chart and editing that bar chart’s settings, then talk about stacked bar charts and when we might want to use them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |