Agent + data / Fictional data

Dashsmith.

An agent with four subagents that turns a data file into a filterable dashboard, then checks its own numbers against the raw file.

Open the dashboard ↗Get the skill and the code

FICTIONAL DATA

Jan to Oct 2026 · by channel

How to use it

  1. Open the sample dashboard. The coffee-shop data in it is made up.
  2. Change the period, the comparison and the filters. Every number and chart follows.
  3. Read "What the data says" for the findings, each one tied to the rows behind it.
  4. To make your own, give the skill and a data file to your AI.

Where it helps most

  • Turning a spreadsheet export into something you can show in a meeting.
  • Monthly sales, operations or survey data that nobody has time to chart.
  • When the numbers must be right: the last step re-counts them from the raw file.

Free to take

Build your own.

Copy the skill, paste it into your own AI, and say what you want different. How to use a skill, step by step ›

Get the skillThe instructions your AI follows. Works in Claude, ChatGPT, Gemini or any other

---
name: dashsmith
description: Turn a data file (CSV or spreadsheet) into a filterable dashboard with written findings, then re-check every number against the raw file. Use when the user shares data and asks for a dashboard, a report or "what does this say".
---

# Dashsmith

Work in four passes. If you can run helpers or subagents, give each pass to a separate one so the checker has not seen how the numbers were made. If you cannot, do them in order and treat pass 4 as if someone else wrote passes 1 to 3.

## Pass 1: profile the file
Read the whole file, not a sample. Report: rows, columns, the date range, what one row is (an order, a visit, a reading), blanks, duplicates, and anything odd (negative amounts, dates in the future, the same thing spelled two ways).
Ask the user at most two questions, only where a wrong guess would change the numbers.

## Pass 2: choose what matters
Pick three to five headline measures and the two or three ways people will want to cut them (time, category, place, customer type). Write each measure as a plain definition: "Revenue = sum of amount after discount, refunds excluded."

## Pass 3: build the dashboard
One self-contained HTML file that works offline:
- A filter bar: period, comparison (previous period or same period last year), and the cuts from pass 2. Every number and chart follows the filters.
- A row of headline numbers, each with its change against the comparison.
- One chart per question, with a title that says what it shows. Lines for time, bars for categories. A "Table" switch on each chart.
- "What the data says": three to five findings in plain sentences, each with the numbers behind it.
- A footer: file name, row count, date range, and the definitions from pass 2.
Readable on a phone. No outside libraries unless the user allows them.

## Pass 4: check it
Without using the dashboard's own code, recompute every headline number and every number quoted in a finding straight from the raw file. List each one: dashboard value, recomputed value, match or not.
Fix anything that does not match and check again. Hand over only when all match, and include the check table.

## Rules
- Never smooth, fill or drop data without saying so in the footer.
- A finding must be something the numbers show, not a guess about why.
- If the file holds personal details, keep them out of the dashboard: totals and groups only.
Get the code2 files, exactly as they run on this site

The sample dashboard’s script (dashboard.js, about 740 KB with the made-up data built in) is not repeated here. The skill builds one for your own file.

index.html19 lines

Raw file

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover">
<title>Coffee Orders Sales · Dashsmith demo</title>
<meta name="description" content="A dashboard Dashsmith built from fictional coffee-roaster order data. Every figure is recomputed in the browser.">
<meta name="robots" content="noindex">
<link rel="icon" href="../../favicon.svg" type="image/svg+xml">
<link rel="stylesheet" href="./dashboard.css">
</head>
<body>

<div class="wrap" id="app"></div>
<div class="tip" id="tip" hidden></div>
<script src="./dashboard.js"></script>
</body>
</html>
dashboard.css286 lines

Raw file

:root{color-scheme:light;box-sizing:border-box;padding-top:env(safe-area-inset-top,0px);padding-bottom:env(safe-area-inset-bottom,0px)}html{scroll-padding-top:env(safe-area-inset-top,0px)}body{margin:0;padding:0;font:14px -apple-system,BlinkMacSystemFont,sans-serif;background:#fff;color:#000}img{max-width:100%}[hidden]:not([hidden=until-found i]){display:none!important}

/* Layout: a workbench. Title and page tabs on top, one filter row that scopes
   everything below it, a band of key figures, then a two-column grid of
   charts on raised sheets. Every figure is recomputed in the browser from the
   embedded data whenever a filter changes. */
:root {
  --page: #f6f6f3;
  --sheet: #fcfcfb;
  --ink: #0b0b0b;
  --ink-2: #52514e;
  --ink-3: #86847e;
  --rule: #e1e0d9;
  --axis: #c3c2b7;
  --ring: rgba(11, 11, 11, 0.10);
  --wash: rgba(11, 11, 11, 0.04);
  --up: #006300;
  --down: #b42a2a;
  --good: #0ca30c;
  --warning: #fab219;
  --critical: #d03b3b;
  --s0: #b3b1a8;
  --s1: #2a78d6; --s2: #eb6834; --s3: #1baf7a; --s4: #eda100;
  --s5: #e87ba4; --s6: #008300; --s7: #6250d6; --s8: #e34948;
  --on-s4: #0b0b0b;
  --heat-lo: #dbe9fb; --heat-hi: #0d366b; --heat-ink: #ffffff;
  --font-text: Inter, system-ui, -apple-system, "Segoe UI", sans-serif;
  --font-head: "Space Grotesk", Inter, system-ui, -apple-system, "Segoe UI", sans-serif;
}
@media (prefers-color-scheme: dark) {
  :root:not([data-theme="light"]) {
    --page: #0d0d0d; --sheet: #1a1a19; --ink: #f0efec; --ink-2: #c3c2b7; --ink-3: #8f8d86;
    --rule: #2c2c2a; --axis: #383835; --ring: rgba(255, 255, 255, 0.10); --wash: rgba(255, 255, 255, 0.05);
    --up: #2fbf2f; --down: #e66767; --good: #0ca30c; --warning: #fab219; --critical: #e05252;
    --s0: #5d5b55;
    --s1: #3987e5; --s2: #d95926; --s3: #199e70; --s4: #c98500;
    --s5: #d55181; --s6: #008300; --s7: #9085e9; --s8: #e66767;
    --on-s4: #ffffff;
    --heat-lo: #1c2f47; --heat-hi: #9ec5f4; --heat-ink: #0b0b0b;
    color-scheme: dark;
  }
}
:root[data-theme="dark"] {
  --page: #0d0d0d; --sheet: #1a1a19; --ink: #f0efec; --ink-2: #c3c2b7; --ink-3: #8f8d86;
  --rule: #2c2c2a; --axis: #383835; --ring: rgba(255, 255, 255, 0.10); --wash: rgba(255, 255, 255, 0.05);
  --up: #2fbf2f; --down: #e66767; --good: #0ca30c; --warning: #fab219; --critical: #e05252;
  --s0: #5d5b55;
  --s1: #3987e5; --s2: #d95926; --s3: #199e70; --s4: #c98500;
  --s5: #d55181; --s6: #008300; --s7: #9085e9; --s8: #e66767;
  --on-s4: #ffffff;
  --heat-lo: #1c2f47; --heat-hi: #9ec5f4; --heat-ink: #0b0b0b;
  color-scheme: dark;
}

*, *::before, *::after { box-sizing: border-box; }
[hidden] { display: none !important; }
body {
  margin: 0;
  background: var(--page);
  color: var(--ink);
  font: 400 14px/1.5 var(--font-text);
  -webkit-font-smoothing: antialiased;
}
body::before { content: ""; position: fixed; inset: 0 0 auto; height: env(safe-area-inset-top, 0px); z-index: 10; background: var(--page); }
.wrap {
  max-width: 1240px;
  margin: 0 auto;
  padding-block: 28px 48px;
  padding-left: max(16px, env(safe-area-inset-left, 0px));
  padding-right: max(16px, env(safe-area-inset-right, 0px));
  display: flex;
  flex-direction: column;
  gap: 18px;
}
h1, h2, h3, p { margin: 0; }
h1, h2, h3 { font-family: var(--font-head); text-wrap: balance; }
button, select, input { font: inherit; color: inherit; }
:focus-visible { outline: 2px solid var(--s1); outline-offset: 2px; border-radius: 4px; }

/* Header */
.top { display: flex; flex-wrap: wrap; align-items: flex-end; justify-content: space-between; gap: 12px 32px; }
.top-main { display: flex; flex-direction: column; gap: 6px; min-width: 0; max-width: 760px; }
.eyebrow { font-size: 12px; letter-spacing: 0.06em; text-transform: uppercase; color: var(--ink-3); font-weight: 500; }
h1 { font-size: clamp(24px, 3.4vw, 32px); line-height: 1.12; font-weight: 600; letter-spacing: -0.02em; }
.sub { font-size: 15px; color: var(--ink-2); max-width: 66ch; }
.stamp { font-size: 12px; color: var(--ink-3); text-align: right; line-height: 1.6; }
.stamp b { color: var(--ink-2); font-weight: 500; }
.tabs { display: flex; gap: 4px; flex-wrap: wrap; border-bottom: 1px solid var(--rule); }
.tab { background: none; border: 0; border-bottom: 2px solid transparent; margin-bottom: -1px; padding: 8px 12px; font-weight: 500; color: var(--ink-3); cursor: pointer; }
.tab:hover { color: var(--ink); }
.tab[aria-selected="true"] { color: var(--ink); border-bottom-color: var(--ink); }

/* Filter row */
.filters { display: flex; flex-wrap: wrap; align-items: center; gap: 8px; padding-block: 8px; background: var(--page); }
.ctl { display: inline-flex; align-items: center; gap: 6px; font-size: 13px; }
.ctl > span { color: var(--ink-3); }
.field, .dd-btn {
  appearance: none; -webkit-appearance: none; height: 32px; padding: 0 10px; border: 1px solid var(--ring); border-radius: 8px;
  background-color: var(--sheet); font-size: 13px; cursor: pointer; max-width: 100%;
}
select.field, .dd-btn {
  padding-right: 26px;
  background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 10 6'%3E%3Cpath d='M1 1l4 4 4-4' fill='none' stroke='%2386847e' stroke-width='1.6' stroke-linecap='round' stroke-linejoin='round'/%3E%3C/svg%3E");
  background-repeat: no-repeat; background-position: right 9px center; background-size: 9px;
}
input.field { cursor: text; width: 132px; }
.field:hover, .dd-btn:hover { border-color: var(--axis); }
.dd { position: relative; }
.dd-btn b { font-weight: 500; }
.dd-btn.on { border-color: var(--s1); }
.dd-panel { position: absolute; top: 36px; left: 0; z-index: 8; min-width: 200px; max-width: min(300px, calc(100vw - 32px)); max-height: 300px; overflow: auto; background: var(--sheet); border: 1px solid var(--ring); border-radius: 10px; box-shadow: 0 10px 30px rgba(0, 0, 0, 0.16); padding: 6px; }
.dd-panel.right { left: auto; right: 0; }
.dd-panel label { display: flex; align-items: center; gap: 8px; padding: 6px 8px; border-radius: 6px; cursor: pointer; font-size: 13px; }
.dd-panel label:hover { background: var(--wash); }
.dd-panel i { width: 8px; height: 8px; border-radius: 2px; flex: none; }
.dd-panel .clear { width: 100%; text-align: left; background: none; border: 0; border-top: 1px solid var(--rule); margin-top: 4px; padding: 8px; color: var(--ink-2); cursor: pointer; font-size: 13px; }
.reset { height: 32px; padding: 0 10px; border: 0; background: none; color: var(--ink-2); text-decoration: underline; text-underline-offset: 3px; cursor: pointer; font-size: 13px; }
.sep { width: 1px; height: 20px; background: var(--rule); margin-inline: 4px; }
@media (min-width: 861px) {
  .filters { position: sticky; top: env(safe-area-inset-top, 0px); z-index: 6; border-bottom: 1px solid var(--rule); }
}

/* Sheets */
.sheet { background: var(--sheet); border: 1px solid var(--ring); border-radius: 12px; min-width: 0; }
.sheet-pad { padding: 16px 18px 14px; }
.label { font-size: 13px; color: var(--ink-2); font-weight: 500; }
.page { display: flex; flex-direction: column; gap: 16px; }

/* KPI band */
.kpis { display: flex; flex-wrap: wrap; gap: 1px; background: var(--rule); border: 1px solid var(--ring); border-radius: 12px; overflow: hidden; }
.kpi { flex: 1 1 180px; background: var(--sheet); padding: 14px 18px; display: flex; flex-direction: column; gap: 4px; min-width: 0; }
.kpi-row { display: flex; align-items: flex-end; justify-content: space-between; gap: 12px; }
.kpi-num { font-size: 26px; line-height: 1.15; font-weight: 600; letter-spacing: -0.02em; }
.kpi svg.spark { width: 84px; height: 30px; flex: none; overflow: visible; }
.delta { display: inline-flex; align-items: center; gap: 6px; font-size: 12px; color: var(--ink-3); flex-wrap: wrap; min-height: 18px; }
.delta .chg { display: inline-flex; align-items: center; gap: 4px; font-weight: 600; font-variant-numeric: tabular-nums; }
.delta .chg.pos { color: var(--up); }
.delta .chg.neg { color: var(--down); }
.delta .chg.flat { color: var(--ink-2); }
.delta svg { width: 9px; height: 9px; flex: none; }

/* Findings */
.lead { display: grid; grid-template-columns: minmax(0, 1.55fr) minmax(0, 1fr); gap: 16px; align-items: start; }
.findings { display: flex; flex-direction: column; }
.findings > h2 { font-size: 16px; font-weight: 600; letter-spacing: -0.01em; }
.findings > p { font-size: 12px; color: var(--ink-3); padding-bottom: 8px; }
.finding { display: grid; grid-template-columns: 20px minmax(0, 1fr); gap: 2px 10px; padding: 11px 0; border-top: 1px solid var(--rule); }
.finding svg { width: 16px; height: 16px; margin-top: 2px; }
.finding h3 { font: 600 14px/1.35 var(--font-text); }
.finding p { grid-column: 2; color: var(--ink-2); font-size: 13px; }
.finding .tone { grid-column: 2; font-size: 11px; letter-spacing: 0.06em; text-transform: uppercase; color: var(--ink-3); font-weight: 500; }
.t-good { color: var(--good); } .t-warning { color: var(--warning); } .t-critical { color: var(--critical); } .t-neutral { color: var(--ink-3); }

/* Chart grid */
.grid { display: grid; grid-template-columns: repeat(2, minmax(0, 1fr)); gap: 16px; }
.grid .wide { grid-column: 1 / -1; }
.card { display: flex; flex-direction: column; gap: 12px; }
.card-head { display: flex; align-items: flex-start; justify-content: space-between; gap: 12px; }
.card-head h2 { font-size: 16px; font-weight: 600; letter-spacing: -0.01em; line-height: 1.25; }
.card-head p { font-size: 12px; color: var(--ink-3); }
.toggle { flex: none; font: 500 12px/1 var(--font-text); color: var(--ink-2); background: transparent; border: 1px solid var(--ring); border-radius: 7px; padding: 6px 9px; cursor: pointer; }
.toggle:hover { background: var(--wash); }
.toggle[aria-pressed="true"] { background: var(--wash); color: var(--ink); }
.legend { display: flex; flex-wrap: wrap; gap: 6px 16px; font-size: 12px; color: var(--ink-2); }
.legend span { display: inline-flex; align-items: center; gap: 6px; }
.legend i { width: 10px; height: 10px; border-radius: 3px; flex: none; }
.legend i.ln { height: 2px; width: 14px; border-radius: 1px; }
.plot { position: relative; min-width: 0; }
.plot svg { display: block; width: 100%; overflow: visible; }
.plot svg:focus { outline: none; }
.plot svg:focus-visible { outline: 2px solid var(--s1); outline-offset: 4px; border-radius: 6px; }
.empty { color: var(--ink-3); font-size: 13px; padding: 36px 0; text-align: center; }
svg text { font-family: var(--font-text); font-size: 11.5px; fill: var(--ink-3); font-variant-numeric: tabular-nums; }
svg text.strong { fill: var(--ink-2); font-weight: 500; }
.gridline { stroke: var(--rule); stroke-width: 1; }
.baseline { stroke: var(--axis); stroke-width: 1; }
.cross { stroke: var(--axis); stroke-width: 1; }
.c0 { --c: var(--s0); }
.c1 { --c: var(--s1); } .c2 { --c: var(--s2); } .c3 { --c: var(--s3); } .c4 { --c: var(--s4); }
.c5 { --c: var(--s5); } .c6 { --c: var(--s6); } .c7 { --c: var(--s7); } .c8 { --c: var(--s8); }
.ln-path { fill: none; stroke: var(--c); stroke-width: 2; stroke-linejoin: round; stroke-linecap: round; }
.ar-path { fill: var(--c); opacity: 0.10; stroke: none; }
.dot { fill: var(--c); stroke: var(--sheet); stroke-width: 2; }
.fill { fill: var(--c); }
.bg { background: var(--c); }
.col.on .fill, .seg.on, .bars .track.on .bar { filter: brightness(1.12) saturate(1.1); }
.hit { fill: transparent; }
.col:focus { outline: none; }
.col:focus-visible .hit { stroke: var(--s1); stroke-width: 2; }

/* Ranked bars */
.bars { display: grid; grid-template-columns: minmax(0, max-content) minmax(0, 1fr); gap: 8px 14px; align-items: center; font-size: 13px; }
.bars .name { color: var(--ink-2); overflow-wrap: anywhere; max-width: 180px; }
.bars .track { display: flex; align-items: center; gap: 8px; min-width: 0; border-radius: 4px; padding-block: 2px; }
.bars .track.click { cursor: pointer; }
.bars .bar { height: 14px; border-radius: 0 4px 4px 0; min-width: 2px; flex: none; }
.bars .bar.neg { border-radius: 4px 0 0 4px; }
.bars .track.div { background: linear-gradient(var(--axis), var(--axis)) no-repeat var(--zero) 0 / 1px 100%; }
.bars .val { color: var(--ink); font-weight: 500; font-variant-numeric: tabular-nums; white-space: nowrap; }
.bars .off .bar { background: var(--s0); }
.bars .name.off, .bars .off .val { color: var(--ink-3); }

/* Segmented bar */
.segbar { display: flex; gap: 2px; height: 28px; }
.seg { border-radius: 4px; min-width: 3px; display: flex; align-items: center; padding-left: 8px; font-size: 12px; font-weight: 600; color: #fff; white-space: nowrap; }
.seg.click { cursor: pointer; }
.seg.c4 { color: var(--on-s4); }
.seg.c0 { color: var(--ink); }
.seg.off { opacity: 0.35; }
.seg span { visibility: hidden; }
.seg.fits span { visibility: visible; }
.segwrap { display: flex; flex-direction: column; gap: 12px; padding-block: 4px 2px; }

/* Heatmap */
.heat { display: grid; gap: 2px; align-items: center; font-size: 12px; min-width: min-content; }
.heat .rl { color: var(--ink-2); padding-right: 10px; white-space: nowrap; max-width: 150px; overflow: hidden; text-overflow: ellipsis; }
.heat .cl { color: var(--ink-3); text-align: center; white-space: nowrap; font-size: 11px; padding-top: 4px; overflow: visible; }
.cell { height: 26px; border-radius: 3px; background: color-mix(in oklab, var(--heat-hi) calc(var(--t) * 100%), var(--heat-lo)); display: flex; align-items: center; justify-content: center; font-size: 11px; font-variant-numeric: tabular-nums; color: var(--ink); min-width: 18px; }
.cell.hi { color: var(--heat-ink); }
.cell.na { background: var(--wash); }
.cell:hover, .cell:focus-visible { outline: 2px solid var(--ink); outline-offset: 0; }
.cell span { visibility: hidden; }
.heat.vals .cell span { visibility: visible; }
.hscale { display: flex; align-items: center; gap: 8px; font-size: 11.5px; color: var(--ink-3); padding-top: 10px; }
.hscale i { width: 120px; height: 8px; border-radius: 4px; background: linear-gradient(90deg, var(--heat-lo), var(--heat-hi)); }

/* Tables */
.tscroll { overflow-x: auto; }
table { border-collapse: collapse; width: 100%; font-size: 13px; }
th, td { padding: 8px 12px; text-align: left; border-bottom: 1px solid var(--rule); white-space: nowrap; }
th { font-weight: 500; color: var(--ink-3); font-size: 12px; }
td.num, th.num { text-align: right; font-variant-numeric: tabular-nums; }
tbody tr:last-child td { border-bottom: 0; }
tbody tr:hover td { background: var(--wash); }
tbody tr.click { cursor: pointer; }
tbody tr.off td { color: var(--ink-3); }
th button { all: unset; cursor: pointer; display: inline-flex; align-items: center; gap: 4px; }
th button:hover { color: var(--ink); }
th button:focus-visible { outline: 2px solid var(--s1); outline-offset: 2px; border-radius: 4px; }
th[aria-sort] button { color: var(--ink); }
th .arr { font-size: 9px; width: 8px; }
td:first-child, th:first-child { padding-left: 0; position: sticky; left: 0; background: var(--sheet); }
tbody tr:hover td:first-child { background: linear-gradient(var(--wash), var(--wash)), var(--sheet); }
td:last-child, th:last-child { padding-right: 0; }
.ib { display: inline-flex; align-items: center; justify-content: flex-end; gap: 10px; }
.ib i { display: block; height: 8px; border-radius: 0 3px 3px 0; background: var(--s1); min-width: 1px; }
.ib u { display: block; width: 72px; text-decoration: none; }
.ib span { text-align: right; }
tr.off .ib i { background: var(--s0); }
td .chg { display: inline-flex; align-items: center; gap: 4px; font-weight: 500; }
td .chg.pos { color: var(--up); } td .chg.neg { color: var(--down); }
td .chg svg { width: 8px; height: 8px; }

/* Tooltip */
.tip { position: fixed; z-index: 20; pointer-events: none; background: var(--sheet); color: var(--ink); border: 1px solid var(--ring); border-radius: 10px; box-shadow: 0 8px 28px rgba(0, 0, 0, 0.14); padding: 10px 12px; font-size: 12px; min-width: 120px; max-width: 280px; }
.tip .tt { color: var(--ink-3); padding-bottom: 6px; }
.tip .tr { display: grid; grid-template-columns: 14px minmax(0, 1fr) auto; align-items: center; gap: 8px; padding: 2px 0; }
.tip .tr i { height: 2px; width: 14px; border-radius: 1px; }
.tip .tr .n { color: var(--ink-2); overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
.tip .tr .v { font-weight: 600; font-variant-numeric: tabular-nums; }
.tip .tot { border-top: 1px solid var(--rule); margin-top: 4px; padding-top: 6px; }
.tip .hint { color: var(--ink-3); padding-top: 6px; }

/* Footer */
.foot { display: grid; grid-template-columns: minmax(0, 1.4fr) minmax(0, 1fr); gap: 20px 40px; border-top: 1px solid var(--rule); padding-top: 20px; margin-top: 8px; font-size: 13px; color: var(--ink-2); }
.foot h2 { font: 500 12px/1.4 var(--font-text); letter-spacing: 0.06em; text-transform: uppercase; color: var(--ink-3); padding-bottom: 8px; }
.foot ul { margin: 0; padding-left: 18px; display: flex; flex-direction: column; gap: 4px; max-width: 70ch; }
.pipe { display: flex; flex-direction: column; gap: 6px; }
.pipe div { display: grid; grid-template-columns: 120px minmax(0, 1fr); gap: 10px; }
.pipe b { font-weight: 500; color: var(--ink); }

@media (max-width: 860px) {
  .lead, .grid, .foot { grid-template-columns: minmax(0, 1fr); }
  .stamp { text-align: left; }
  .wrap { padding-block: 20px 36px; gap: 14px; }
  .sheet-pad { padding: 14px 14px 12px; }
  .sep { display: none; }
}
@media (max-width: 480px) {
  .kpi { flex-basis: 150px; }
  .kpi svg.spark { display: none; }
}
@media (prefers-reduced-motion: no-preference) {
  .toggle, .col .fill, .seg, .bars .bar, .tab { transition: filter 0.12s, background-color 0.12s, color 0.12s, opacity 0.12s; }
}

Have an idea of your own?

Look around your day, find the thing that wastes your time, and build the fix. Everything here is free to help you start. If you would rather I built it, or you just want to talk an idea through, write to me.

Write to me Email meHow to use what is here