Building dashboards
This chapter explains how to assemble saved questions into a dashboard, arrange it, and keep it readable as it grows.
1. Start from a copy, or from nothing
You cannot edit the dashboard you land on. Staple Dashboard is provided by Staple, is identical for everyone in your organisation, and is read-only. There are two ways to get one you can change.
Duplicate it, if most of what you want is already there:
- Open Business Dashboard from the Staple sidebar.
- Select … above the dashboard, then Duplicate.
- Name the copy and select Duplicate.
You now own a dashboard you can change. The original stays untouched as a reference, and everyone else’s copy is unaffected by what you do to yours.
Start from nothing, if you want only your own charts. Select New dashboard at the top of the dashboard list. Name it for what it answers, not for who made it: Daily upload volume is findable in six months, Sam's dashboard is not.
2. Adding charts
There are three routes onto a dashboard, and all three are worth knowing because they match different ways of thinking.
First get into edit mode. On an empty dashboard select Add a chart. On one that already has cards, select the pencil in the dashboard’s top right.
The edit bar appears, and with it a toolbar. Select Add questions, the +.
A panel opens on the right. From there:
A question someone already saved. Pick it from the list in that panel. It lands as a card. Worth scanning before you build anything, because the answer may already exist.
A question that does not exist yet. Select New Question. The builder opens inside the dashboard and the result lands as a card when you save. See Building a chart yourself.
A chart you asked AI for. Charts saved from Ask AI appear in the same list as any other saved question. Use the Search… box to find it by the name you gave it.
2.1 Adding the scorecard to the worked example
The line chart from Building a chart yourself shows the shape of upload volume. A single total gives readers the headline. Build it the second way:
- Select the pencil, then Add questions, then New Question.
- For data, choose Analytics Documents.
- Select Pick a function or metric, then Count of rows.
- Select Save, name it, and save.
- Select Save again, on the dashboard’s edit bar, to save the dashboard.
Two saves, and they do different things. The first saves the question. The second saves the dashboard that now holds it. Miss the second and the card is gone when you reload.
3. Arranging the layout
Cards land where there is room, which is rarely where you want them.
- Select the pencil to enter edit mode.
- Drag a card by its body to move it.
- Drag the handle at its bottom-right corner to resize it.
- Select Save on the edit bar.
What makes a dashboard readable is mostly restraint:
- Headline number top left. It is where people look first.
- One idea per row. Two charts that answer unrelated questions should not sit side by side.
- Wide for time, narrow for totals. A line chart squeezed into a quarter-width card is unreadable; a single number stretched across the full width is a waste.
4. Text and heading cards
A dashboard with eight charts and no words makes every reader work out the structure for themselves. Text cards fix that.
In edit mode, the toolbar offers Add a heading or text box, and next to it Add a link or iframe and Add section. Put a heading above a group of charts to say what the group is for. Treat them as section headings, not commentary.
5. Editing a chart that is already on a dashboard
You do not have to go and find the original question.
- Select the … on the card.
- Select Edit question.
- Change what you need. The chart type sits top left, showing the current type, and the picker offers Table, Number, Gauge, Progress, Detail, Bar, Line, Pie, Row, Area, Combo, Pivot Table, Trend, Funnel, Map, Scatter, Waterfall, Box Plot, Sankey and Treemap.
- Select Save, then Save changes.
This edits the question everywhere it appears. If the same question is on someone else’s dashboard, they get your change too. When you want a variation rather than a change, duplicate the question first.
5.1 Retitling a card without touching the question
Sometimes the chart is right and only its name is wrong for this dashboard.
- Select the pencil to enter edit mode.
- Hover the card. A row of icons appears above it.
- Select Visualize another way, the second icon in that row.
- Edit the title at the top of the panel that opens.
- Select Save, then Save on the edit bar.
This retitles the card, not the question. The saved question keeps its own name and the same chart on anyone else’s dashboard is unaffected. That is the opposite of section 5’s warning, and it is why this is the safer route when all you want is a clearer label.
Once a card has been through this panel, its icon is relabelled Edit visualization rather than Visualize another way. Same place, same job.
6. Goal lines
A goal line draws a horizontal marker across a chart at a value you choose, so a reader can see at a glance whether the line is above or below it.
- Select the … on the card, then Edit question.
- Open the settings, the gear icon.
- Go to Display.
- Turn Goal line on.
- Set Goal value. Pick one inside the range your chart actually reaches. Goal label renames the marker if
Goalis not what your reader calls it. - Select Save, then Save changes.
Goal lines have a second job: a chart needs one before it can carry an alert. See Alerts. It is a good reason to set one now even if you do not need the visual marker.