Build dashboards
Create charts
The ways to add a chart, and the Chart Builder.
A chart shows one question about one dataset, such as "sales by region". This page covers the ways to add a chart, and the Chart Builder. What viewers can do when they click a chart is in Chart actions.
Before you start
Open a dashboard in the builder and pick a dataset. The dataset must be attached to the dashboard's collection. See Collections.
Ways to add a chart
| Way | How | Best for |
|---|---|---|
| From the Data panel | Drag a column onto the canvas. | A quick first chart. |
| From the insert rail | Choose Chart, draw its frame, then add data. | Placing a chart exactly where you want it. |
| From the gallery | Pick saved or suggested charts. | Reusing charts, or adding several at once. |
| Field by field | Open the Chart Builder and fill each part of the chart. | Full control over the chart. |
From the Data panel
Open Data on the insert rail and drag a column onto the canvas. GOAT picks a starting chart from the column:
- a number column gives an Indicator, a single big number;
- a date column gives a Line chart over time;
- any other column gives a Bar chart.
Drop a column on a chart that is already placed to add it there. The chart takes it where it fits best. Hold Alt (Option on a Mac) while you drop to make a filter instead.
The + button on a column's row offers the same choices: New chart, "Use in" followed by the selected chart's name, or Use as filter.
From the insert rail
- Choose Chart on the insert rail, then Blank chart.
- Draw the chart's frame on the canvas.
- Drag a column into the empty frame, or choose From gallery or Chart builder in it.
From the gallery
Choose Chart, then From the gallery…, or From gallery in an empty chart frame. The Chart gallery lists, for each dataset:
- Suggested: charts GOAT proposes from the dataset's columns.
- Saved charts: charts already saved on that dataset. Unused shows only those on no dashboard.
- Pick one chart, or tick several.
- Choose Add 1 chart, or Add the number you picked.
The first chart fills the frame you drew. Others fill any empty chart frames, then the free space. One Undo takes them all back.
Link to the original decides how a saved chart is added. On, the dashboard shows the saved chart itself, so later edits to it reach every dashboard that shows it. Off, each chart is added as an independent copy. Charts from another collection are always added as copies.
Field by field
Open the Chart Builder in any of these ways:
- Double-click a chart on the canvas.
- Select a chart and choose Open in Chart Builder at the foot of the panel.
- Choose Chart builder in the gallery or in an empty chart frame.
Building a chart field by field
| Area | What it holds |
|---|---|
| On the left | The dataset's fields. Click a field to place it, or drag it into a well. |
| In the middle | The wells for the chart type, such as X axis and Values, over a live preview. |
| On the right | Chart type, then the chart's options. |
| Top bar | The chart's title, Auto render, Preview as, Cancel, and Done. |
Build the chart
- Choose a Chart type. More… opens every type, with the ones your fields cannot fill dimmed and the reason shown. See Chart types.
- Drop fields into the wells. The preview redraws as you go. With Auto render off, choose Run to redraw.
- Click a value field to change how it is summed up: Sum, Average, Median, Minimum, Maximum, Count, or Distinct count.
- Set the options on the right: Sort By, Max data points, Filters, and the look of the chart.
- Choose Done. When you are adding a new chart, the button reads Add to dashboard.
Cancel drops your changes and keeps the saved chart as it was.
The empty builder may also offer up to four questions to start from, such as "How is it moving?" or "Which is bigger?". Pick one to fill the wells for you.
Charts are shared
A saved chart can sit on several dashboards. Editing it in the Chart Builder changes it everywhere it is placed. The panel says "Shared by every dashboard that uses this chart."
That includes Live dashboards: their viewers see the edit within about a minute, with no publish. To change one placement alone, use Save as new chart. To add a saved chart you mean to change, turn Link to the original off in the gallery.
If someone else saved the chart while you were editing it, GOAT offers Load theirs or Save mine as a new chart.
A chart's settings on the canvas
Select a chart on the canvas and the panel shows:
| Section | What it sets |
|---|---|
| Element | The title, whether it shows, a description shown behind the ⓘ beside the title, and Allow raw data. |
| Data | The dataset and the chart's fields. Filters, sort, and limit are in the Chart Builder. |
| Actions | What happens when a viewer clicks the chart. See Chart actions. |
| A section named for the chart type, then Axes, Analytics, and Interaction | The chart's look: marks, labels, axes, tooltips, and zoom. |
| Card | The card around the chart: fill, border, shadow, padding, and corners. |
| Layout | The chart's position and size, for each screen size. |
Common problems
| What you see | What to check |
|---|---|
| A column cannot be dropped on a chart | A chart draws from one dataset. The column is on another dataset, or is offered for filters only. |
| A chart type is dimmed | The fields in the wells do not suit it. The card says what it needs. |
| An edit changed the chart on another dashboard, or on a Live one | The chart is shared. Use Save as new chart for a separate copy. |