These are the docs for the Metabase master branch. Some features documented here may not yet be available in the latest release. Check out the docs for the latest version, Metabase v0.49.

Visualizing data

While tables are useful for looking up information or finding specific numbers, it’s usually easier to see trends and make sense of data using charts.

To change how the answer to your question is displayed, click on the Visualization button in the bottom-left of the screen to open the visualization sidebar.

Visualization options

If a particular visualization doesn’t really make sense for your answer, that option will appear in the “Other charts” section. You can still select one of these other charts, though you might need to fiddle with the chart options to make the chart work with your data.

Not sure which visualization type to use? Check out Which chart should you use?

Visualization options

Options for a chart

Each visualization type has its own advanced options.

To change the settings for a specific chart, for example a row chart, you could either:

  • Click on the gear icon in the bottom left of the chart (next to the Visualization button, or
  • Click on Visualization in the bottom left of the chart, then hover over the currently selected chart and click on the gear icon that pops up.

Visualization types

Metabase ships with a bunch of different visualizations types:

Numbers

The Numbers option is for displaying a single number, nice and big.

Number

The Trend visualization is great for displaying how a single number has changed between two time periods.

Trend settings

Detail

The Detail visualization shows a single result record (row) in an easy-to-read, two-column display.

Detail of a record in the account table

Progress bars

Progress bars are for comparing a single number to a goal value that you set.

Progress bar

Gauges

Gauges allow you to show a single number in the context of a set of colored ranges that you can specify.

Gauge

Tables

The Table option is good for looking at tabular data (duh), or for lists of things like users or orders.

Conditional formatting

Pivot tables

Pivot tables allow you swap rows and columns, group data, and include subtotals in your table. You can group one or more metrics by one or more dimensions.

Pivot table options

Line charts

Line charts are best for displaying the trend of a number over time, especially when you have lots of x-axis values. For more, check out our Guide to line charts and Time series analysis tutorials.

Trend lines

Bar charts

Bar charts are great for displaying a number grouped by a category (e.g., the number of users you have by country).

Bar chart

Area charts

Area charts are useful when comparing the proportions of two metrics over time. Both bar and area charts can be stacked.

Stacked area chart

Combo charts

Combo charts let you combine bars and lines (or areas) on the same chart.

Line + bar

Histograms

If you have a bar chart like Count of Users by Age, where the x-axis is a number, you’ll get a special kind of bar chart called a histogram where each bar represents a range of values (called a “bin”).

Histogram

Row charts

Row charts are good for visualizing data grouped by a column that has a lot of possible values, like a Vendor or Product Title field.

Row chart

Waterfall charts

Waterfall charts are a kind of bar chart useful for visualizing results that contain both positive and negative values.

Waterfall chart

Scatterplots and bubble charts

Scatterplots are useful for visualizing the correlation between two variables, like comparing the age of your people using your app vs. how many dollars they’ve spent on your products.

Scatter

Pie chart or donut charts

A pie chart or donut chart can be used when breaking out a metric by a single dimension, especially when the number of possible breakouts is small, like users by gender.

Donut

Funnel charts

Funnels are commonly used in e-commerce or sales to visualize how many customers are present within each step of a checkout flow or sales cycle. At their most general, funnels show you values broken out by steps, and the percent decrease between each successive step.

Funnel

Maps

When you select the Map visualization, Metabase will automatically try and pick the best kind of map to use based on the table or result set.

Region map

Formatting data in charts

While we’re talking about formatting, we thought you should also know that you can access formatting options for the columns used in a chart. Just open the visualization settings and select the Data tab:

Chart formatting

Then click on the gear icon next to the column that you want to format. Dates, numbers, and currencies tend to have the most useful formatting options.

Chart formatting options

Further reading

Read docs for other versions of Metabase.

Thanks for your feedback!

See something that needs fixing? Propose a change.