Reports vs dashboards: which one answers which question?
Reports vs dashboards is a difference of question. A dashboard is one screen with a few numbers and charts that answers "how do things stand right now?". You glance at it many times a week. A report answers "what happened over this month or year, and why?". You read it once, with care. A business needs both.
An everyday comparison
Think of a car. The dashboard shows your speed and how much fuel is left. You glance at it while you drive, and you act at once: slow down, fill up. The service report from the garage is different. It tells you what was checked and what was replaced over the past year. You read it once, at the kitchen table, and decide whether to keep the car.
In a business it is the same. A dashboard helps you act today. A report helps you decide for the next month or year.
The difference in one table
| Dashboard | Report | |
|---|---|---|
| Question | Where are we now? | What happened, and why? |
| Time | Right now, or today | A finished month, quarter or year |
| How it is read | A glance, many times | From start to end, once |
| Who reads it | The people doing the work | Owners, managers, the bank |
| Leads to | An action today | A decision for later |
Six questions, sorted
- How many orders are open at this moment? Dashboard.
- Which invoices are overdue? Dashboard.
- Who has time for a new customer this week? Dashboard.
- How did this quarter compare with the last one? Report.
- Which customers earned us money last year? Report.
- What does the bank need to see for the loan? Report.
A quick test helps. If the answer would be different in an hour, it belongs on a dashboard. If the answer must still be the same next year, it is a report.
What makes a dashboard useful
- Few numbers. Five to eight are enough. Every extra chart takes attention away from the others.
- Each number leads to an action. If nobody would do anything differently when it changes, remove it.
- The details are one click away. "Seven invoices overdue" only helps when you can open the seven.
What makes a report useful
- A fixed period. March stays March, even if someone corrects a number later.
- A comparison. A figure alone says little. Next to last month or last year, it says something.
- A few written sentences. What stands out, and what follows from it. A dashboard cannot give you that.
Two common mix-ups
- The dashboard nobody opens. It was built for a monthly meeting. That is really a report, and it is better sent as one.
- Two sets of numbers. The dashboard takes its figures from one place and the report from another. Then the two do not match, and the meeting is spent on which one is right.
The best set-up uses the same numbers for both. The dashboard shows the figure as it is today. At the end of the month the same figure goes into the report, with a comment.
How Worknano handles this
In Worknano a report and a dashboard are built in the same way. In the report designer you choose which information to show, how to filter and group it, and which chart to use. Then you save the result as a dashboard, a report or a shared insight. Reports can be exported as a spreadsheet. A dashboard can combine figures from different parts of the workspace, and the whole dashboard can be filtered by team or date range. A click on part of a chart opens the entries behind it. Both show the information your team works with every day, so today's number and the monthly figure come from the same place.
Create a free workspace and save your first view as both a dashboard and a report.