![]() ![]() Time series will limit the number of values displayed, whereas the ordinal scale will list each value in the series along the x axis. For the x axis, you can select either time series or ordinal scales. Here you can adjust the scale of the x and y axes. We discuss combo charts in more detail here. You can also combine line and area charts in a combo chart to visualize different aggregations, like the count and sum of order totals shown below. If you want to see the composition of values over time, use a stacked bar chart. If you don’t have that many values plotted over time, consider a bar chart. We’ve been talking strictly about line charts so far, but bar charts and area charts are similar, and there are good reasons to choose them instead of a line chart, depending on what you’re trying to communicate:Īrea charts are typically used to compare values over time. For example, if you’re monitoring sales, and you only want to get notified if a metric dips below a certain threshold, you can add a goal line to specify that threshold and get an email or have a Slack message sent when the line goes under it. Goal lines are especially useful when paired with alerts. You can also add a goal line to plot a horizontal line at your goal value. In the example below, we’ve chosen the grouping field “Created At: Month”: You’ll see the toggle if you’ve chosen exactly one time field from Summarize > Group by. You can add a trend line from the display settings of a time series chart. If you plan on embedding your chart in your app, check out our white labeling option for even more customization. The Display tab lets you change the line color and style, handle missing values, and so on. There are too many settings to cover here without boring you, so we’ll just give you some highlights. To customize your line chart, you can click on the Settings button in the bottom left. And, of course, we can always select a section of the line to filter the results for that time period, and drill through to see those individual, unaggregated records. In the Group by section, under Order, mouse over the Created At field click on the + button to add the grouping.rĪs soon as you add the grouping, Metabase updates the chart: Next, we’ll want to group our order totals by month. Metabase defaults to counting the records, but we’re not interested in the number of orders, so we’ll click on Count and change it to Sum of and select the Total column from Order. Click on the green Summarize button to pull up the Summarize sidebar. (It’s much more common to plot unaggregated rows in visualizations like pin maps, or a scatterplot, e.g., to show each product plotted by price and rating.)Īs an example of an aggregated metric, let’s plot the sum of order totals for each month. To make the chart more legible, we can summarize the data, so each point on the line chart is an aggregate of rows-“buckets” of records. (If you hover over the gray warning triangle in the upper right, you’ll see that Metabase has only plotted 2,000 rows.) That’s technically a line chart, but it looks more like the cardiograph of a startled hummingbird, and that’s even after Metabase has truncated the results shown. ![]() Metabase will automatically plot the line chart: For example, you could show order totals over time by setting the x axis to created_at and the y axis to total. To create a line chart, you’ll need to pick a metric for Metabase to plot over time. Metabase can’t read minds (yet), so it doesn’t know which columns from the Orders table to use for the x and y axes. If you select line chart, Metabase will present you with an empty line chart. Let’s start with how not to create a line chart. Click Visualize, then click the Visualization button in the bottom right to bring up the Visualization sidebar. Choose Raw Data > Sample Database, then pick the Orders table. From the main navigation bar, click on + New > Question, which will take you to Metabase’s notebook editor. Let’s take a look at the Orders table in the Sample Database that ships with Metabase. These charts are typically used to plot a time series (also known as a run chart): a set of markers connected by lines, with the x axis showing the passage of time and the y axis plotting the value of a metric at each moment. Line charts are good for plotting data captured in a sequence, whether that sequence is the passage of time, or steps in a process or flow. For time series, filter out any time period still in progress. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |