8/17/2023 0 Comments Metabase embed grapsAdding a mini bar chart to contextualize the value with respect to the range of values in the column. For example, for scalar values, you can add a mini bar chart to show the value’s position within the range of values in the column. Once again, Metabase knows to present different options for different types of data. The Visualization sidebar for the table visualization. Metabase will include additional columns from other tables linked via foreign key. You can change settings for each of the columns by either clicking on a column’s heading and selecting the gears icon, or via the Settings sidebar. Now let’s see if we can spruce up our table a bit. Clicking on an entity key will bring up a detail view for that record. In figure 4, for example, clicking on the order ID of “3” will bring up details from that order from the Orders table. To make records easier to read, you can click on an entity key column (either a primary or foreign key) to bring up a detail view. Clicking on a scalar value will present options for filtering the table by that value. For instance, by clicking on a value in the Total column, Metabase will present options to filter the data in relation to that value: greater than, less than, and so on. Similarly, if you click on a value in one of the columns, Metabase will present a menu that gives you some options depending on the type of data in that column. Clicking on the column heading for the Created At column and selecting Distribution will generate a line chart that plots the count of orders per month over time.įrom the line chart, you can continue to drill through the data, like zooming in the orders in a section of the chart, or by clicking on a month to view those orders as a table. Figure 2 shows us a GIF of selecting the Distribution option for the Created_At column. If you clicked on the Created At column, you’d get a different set of options, as it wouldn’t make much sense to take the average date, for example. For example, if you click on the heading of the Total($), Metabase will present a set of options, like Distribution, Sum, Average, and so on. The options Metabase presents for each column differ depending on the type of data. So before we customize our table, let’s go through the features that come with it out of the box. It might not seem so special at first, but there’s already a lot going on. Once we click Visualize, here’s our basic table: Fig. This table is distinct from the table visualization, or just “table”-which is the graphical representation of the data in the table, and the occasion for this article. And just to be clear on terms here, the Orders table is the set of relations in the database that houses the Sample Database. To start, we’ll select + New > Question > Raw data > Sample database > Orders. In this article, we’ll work with the Orders table in the Sample Database included with Metabase to explore the table visualization and lay bare its secrets. The table visualization in Metabase comes packed with features-some automatic, and some you can customize for yourself. They may not be as “visual” as a bar chart or a map, but they’re often what you need when you’re working with a lot of fields. Tables are data’s natural habitat, with their columns and rows corresponding to the fields and records of relational databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |