Skip to main content

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?​

TypeUse it toWells
BarRank categories against one or more values.X axis, Values (up to 8), Break by
SymbolShow one mark per value, with no line between them.X axis, Values (up to 8), Break by
ScatterSee whether two values move together.Points, X axis, Y axis, Size (for a bubble chart), Break by
WaterfallShow how each step adds up to a total.Category, Values
Min/maxShow the minimum, average, and maximum of a value per category.Category, Value
Box plotShow how a value spreads per category: median, quartiles, whiskers, and outliers.Category, Value
HeatmapShow one value across two categories, as color.Rows, Columns, Values

Trend: how is it moving?​

TypeUse it toWells
LineFollow a value across time.X axis (best with a date), Values (up to 8), Break by
AreaFollow 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?​

TypeUse it toWells
PieShow shares of one total. Style offers pie, donut, or rose.Category, Values
FunnelShow drop-off through ordered stages.Stage, Values
RadarShow a profile across fixed dimensions.Spokes, Values (up to 4)

Single value: what is the number?​

TypeUse it toWells
IndicatorShow one big number.Value
GaugeShow 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​

TypeUse it toWells
SummaryList groups down the side, with summaries across.Groups (up to 2), Columns (up to 8)
PivotPut 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.

TypeMain options
BarOrientation, stacking, Bar width, Corners, Borders, Fill. A Break by value can be drawn as a line, for a combined chart.
LineCurve, Line width, Missing values, Points, Point size.
AreaFill style, Fill opacity, stacking, the line's options.
SymbolShape, Size.
ScatterSymbol, Point size.
WaterfallTotals, Connectors, Orientation, Corners.
Min/maxStyle, Line style, Orientation, Bar width, Corners.
Box plotOrientation, Whiskers, Show outliers, Fill, Notched box, Box width, Box color.
HeatmapCell gaps, Low color, and color bands.
PieStyle, Hole size, Total in the centre, Group small slices.
FunnelStyle, Fill, Percent of.
RadarStyle, Fill style, Fill opacity, Grid shape, Scale, Spoke names.
IndicatorAlign, number format, and color rules under Analytics.
GaugeStyle, Minimum, Maximum, Target, Thickness, Show percent, Scale labels, color bands.
Summary and PivotShow, Density, Totals, Stripes, borders, and text and fill styles.

To find any option by name, use the search at the top of the panel.

GOAT documentation

Type to search.