Build dashboards
Chart types
Each chart type, when to use it, and what it needs.
GOAT has 16 chart types, grouped by the question they answer. This page helps you pick one. To build a chart, see Create charts.
In the Chart Builder, choose a type under Chart type, or More… for the full list. Types your fields cannot fill are dimmed, with what they need.
How charts use fields
Each type has wells, such as X axis and Values, that take fields:
- A category is a field you group by, such as region or month. Text, dates, and whole numbers work.
- A value is a number GOAT sums up for each group, such as total sales. Choose how it is summed up: Sum, Average, Median, Minimum, Maximum, Count, or Distinct count. A field that is not a number is counted.
Break by splits each group by a second category, such as sales by region, broken by product line.
Compare: which is bigger?
| Type | Use it to | Wells |
|---|---|---|
| Bar | Rank categories against one or more values. | X axis, Values (up to 8), Break by |
| Symbol | Show one mark per value, with no line between them. | X axis, Values (up to 8), Break by |
| Scatter | See whether two values move together. | Points, X axis, Y axis, Size (for a bubble chart), Break by |
| Waterfall | Show how each step adds up to a total. | Category, Values |
| Min/max | Show the minimum, average, and maximum of a value per category. | Category, Value |
| Box plot | Show how a value spreads per category: median, quartiles, whiskers, and outliers. | Category, Value |
| Heatmap | Show one value across two categories, as color. | Rows, Columns, Values |
Trend: how is it moving?
| Type | Use it to | Wells |
|---|---|---|
| Line | Follow a value across time. | X axis (best with a date), Values (up to 8), Break by |
| Area | Follow a trend where the volume matters. | X axis, Values (up to 8), Break by |
After you drop a date on the X axis, pick its grain: day, week, month, and so on.
Composition: what is it made of?
| Type | Use it to | Wells |
|---|---|---|
| Pie | Show shares of one total. Style offers pie, donut, or rose. | Category, Values |
| Funnel | Show drop-off through ordered stages. | Stage, Values |
| Radar | Show a profile across fixed dimensions. | Spokes, Values (up to 4) |
Single value: what is the number?
| Type | Use it to | Wells |
|---|---|---|
| Indicator | Show one big number. | Value |
| Gauge | Show one number against its range or a target. | Value |
Indicator and Gauge charts are saved as a separate kind of chart, so a saved chart of another type cannot be switched to one. Use Save as new chart instead.
Tables: show me the rows
| Type | Use it to | Wells |
|---|---|---|
| Summary | List groups down the side, with summaries across. | Groups (up to 2), Columns (up to 8) |
| Pivot | Put one field down, one across, and the numbers where they meet. | Rows, Columns, Values (1 to 3) |
Tables are not offered in the chart gallery. Build them in the Chart Builder.
Main options by type
Each type's own section in the panel holds its main options. Every type also has Data labels, Format, axes where they apply, Analytics, and Interaction.
| Type | Main options |
|---|---|
| Bar | Orientation, stacking, Bar width, Corners, Borders, Fill. A Break by value can be drawn as a line, for a combined chart. |
| Line | Curve, Line width, Missing values, Points, Point size. |
| Area | Fill style, Fill opacity, stacking, the line's options. |
| Symbol | Shape, Size. |
| Scatter | Symbol, Point size. |
| Waterfall | Totals, Connectors, Orientation, Corners. |
| Min/max | Style, Line style, Orientation, Bar width, Corners. |
| Box plot | Orientation, Whiskers, Show outliers, Fill, Notched box, Box width, Box color. |
| Heatmap | Cell gaps, Low color, and color bands. |
| Pie | Style, Hole size, Total in the centre, Group small slices. |
| Funnel | Style, Fill, Percent of. |
| Radar | Style, Fill style, Fill opacity, Grid shape, Scale, Spoke names. |
| Indicator | Align, number format, and color rules under Analytics. |
| Gauge | Style, Minimum, Maximum, Target, Thickness, Show percent, Scale labels, color bands. |
| Summary and Pivot | Show, Density, Totals, Stripes, borders, and text and fill styles. |
To find any option by name, use the search at the top of the panel.