![]() ![]() Numbers work best when contextualized with other numbers and charts.īut even then, you should consider using the trend visualization if your number can be broken out by time (see comparing one measure over time below). Keep in mind that a single number may lack context, so it’s best used on a dashboard that provides that, such as the number of surveys sent out or how many respondents we had last year. Static numbersįor static numbers, or at least a number that doesn’t change too frequently, use the (appropriately named) number visualization, which is good for at-a-glance values like the count of respondents in a survey. With that out of the way, let’s walk through some common scenarios to help you pick the right viz to communicate your findings. A time series of the count of orders per month, with a trend line. Line charts give a simple shape to the data, making it easy to see if the numbers are trending up, or if they’re cyclical, or what the maximum value was for the past X weeks, and so on. You’re also often going to want to present data as a time series to see how a particular measure changes over time (like a rolling 7-day average), and that’s when you reach for the line chart. Check out How to create a pivot table to summarize your data. If you additionally want to summarize groupings of rows (like seeing the annual subtotal in a grouping of quarterly results), or switch up the columns and rows, you’ll want to use a pivot table. Tables in Metabase are one of the most versatile visualization types, so check out our article on Everything you can do with the table visualization. Maybe you simply want to add or remove a few columns, or add a couple of filters to make it easy for people to look up certain values. Often you’ll want to see a lot of measures at once, list their exact values, and be able to sort those measures. Most of the time you’ll only need the old standbys: tables and line charts. Two charts to rule them allīefore we get into it, we should note: you don’t have to use every chart type to do proper analysis. But don’t get hung up on picking just a single visualization-you can always build a dashboard to show data using multiple charts. Metabase also put some guardrails in place for example, if you don’t have geographic data in your results (like coordinates or State), Metabase will gray out the Map viz. Metabase will always return results as a table, so if you need something other than a table, you’ll have to select a visualization type yourself. ![]() Native queries, however, are a different story. While Metabase guessing the right chart type is nice, it’s not going to work every time: some visualizations require additional input (for example, Metabase can’t automatically know to display a progress bar, as you need to tell Metabase what the goal should be). For example, if you pick a metric, like the count of orders, and group those orders by time, Metabase will automatically select a line chart that plots the order count at each interval. And for questions built using the query builder, Metabase will guess at the appropriate chart to display. Metabase takes care of a lot of the details (like minimizing chart junk) so you can focus on what you want to communicate with your visualization. Picking the right chart comes down to two questions: what does the data look like, and what are you trying to communicate? Let Metabase pick the chart for you When your data contains geographic dimensions.Showing how values are distributed across a numeric range.Relative changes among categories over time.A metric with two or three groups or categories.Showing the relationship between measures. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |