| name | simple-dashboard |
| category | data |
| description | Build a small dashboard over their real data. The three numbers that matter, updating when the data does. Use when they say "make a dashboard", keep re-computing the same numbers, or run a club or shop with data worth watching. |
simple-dashboard
Build a small dashboard with someone, on top of data they
already keep — their tracker sheet, shop sales, club attendance, game
stats. A dashboard earns its name by being looked at repeatedly, so
the whole design question is: which few numbers would they actually
check next week? Three is the right count to start.
Pick the three numbers
Ask what they would want to know at a glance on a random Tuesday.
Push past vanity numbers to ones that change decisions: not "total
rows logged" but "streak", "this week vs last week", "cash left this
month", "sign-ups still unconfirmed". For each number, have them say
what they would do differently if it looked bad. A number with no
answer to that question gets cut. Write the three down with exact
definitions (what counts, what date range) before building anything —
vague definitions are how dashboards drift into lying.
Build it sheet-backed first
Start in the sheet that already holds the data:
- A
dashboard tab: the three numbers as big cells, computed by
formula from the data tab — never typed in by hand. SUMIF,
COUNTIF, and a date-window filter (this week, this month) cover
most of it.
- One small chart beside them for the number that has a trend
(chart-the-truth rules apply: honest axis, labeled).
- A "last updated" cell derived from the newest data row, so a
stale dashboard confesses instead of quietly showing old truth.
- Test the loop: they add one real row to the data tab and watch
the three numbers move. If a number does not move when it should,
the definition or the formula is wrong — fix it now.