:root {
  color-scheme: light;
  --bg: #f5f4f0;
  --panel: #ffffff;
  --panel-2: #f0eee8;
  --ink: #1b1a17;
  --ink-2: #57534a;
  --ink-3: #7a7569;
  --line: #e0dcd2;
  --accent: #2a78d6;
  --accent-ink: #ffffff;
  --dim: #1baf7a;
  --dim-bg: #e5f6ef;
  --meas: #2a78d6;
  --meas-bg: #e6f0fb;
  --good: #1d7a3e;
  --bad: #b3261e;
  --warn: #8a5a00;
  --radius: 14px;
  --shadow: 0 1px 2px rgba(0,0,0,.05), 0 4px 18px rgba(0,0,0,.04);
}
:root[data-theme="dark"] {
  color-scheme: dark;
  --bg: #121316; --panel: #1b1c20; --panel-2: #24262b; --ink: #f2f0ea; --ink-2: #c3c0b6; --ink-3: #96938a; --line: #30333a;
  --accent: #5598e7; --accent-ink: #0b1220; --dim: #4fcf9d; --dim-bg: #15342a; --meas: #86b6ef; --meas-bg: #172a43;
  --good: #6fcf8e; --bad: #ff8a80; --warn: #f0c060; --shadow: none;
}
@media (prefers-color-scheme: dark) {
  :root:not([data-theme="light"]) {
    color-scheme: dark;
    --bg: #121316; --panel: #1b1c20; --panel-2: #24262b; --ink: #f2f0ea; --ink-2: #c3c0b6; --ink-3: #96938a; --line: #30333a;
    --accent: #5598e7; --accent-ink: #0b1220; --dim: #4fcf9d; --dim-bg: #15342a; --meas: #86b6ef; --meas-bg: #172a43;
    --good: #6fcf8e; --bad: #ff8a80; --warn: #f0c060; --shadow: none;
  }
}

* { box-sizing: border-box; }
html, body { margin: 0; }
body { background: var(--bg); color: var(--ink); font: 16px/1.5 system-ui, -apple-system, "Segoe UI", Roboto, sans-serif; -webkit-text-size-adjust: 100%; overflow-x: hidden; }
a { color: var(--accent); }
code, pre { font-family: ui-monospace, SFMono-Regular, Menlo, monospace; }
code { font-size: .92em; background: var(--panel-2); padding: 1px 5px; border-radius: 5px; }
.hidden { display: none !important; }
.visually-hidden { position: absolute; width: 1px; height: 1px; overflow: hidden; clip: rect(0 0 0 0); white-space: nowrap; }
.muted { color: var(--ink-2); }
.small { font-size: .86rem; }
.row { display: flex; gap: 8px; align-items: center; }
.row.wrap { flex-wrap: wrap; }

button, .filebtn { font: inherit; cursor: pointer; border-radius: 10px; border: 1px solid var(--line); background: var(--panel); color: var(--ink); padding: 8px 14px; min-height: 40px; display: inline-flex; align-items: center; justify-content: center; gap: 6px; }
button:disabled { opacity: .5; cursor: default; }
button.primary { background: var(--accent); color: var(--accent-ink); border-color: var(--accent); font-weight: 600; }
button.ghost, .filebtn.ghost { background: transparent; }
button.ghost:hover:not(:disabled), .filebtn:hover { background: var(--panel-2); }
button.primary:hover:not(:disabled) { filter: brightness(1.06); }
button.small, .filebtn.small { min-height: 34px; padding: 4px 11px; font-size: .88rem; }
button:focus-visible, input:focus-visible, select:focus-visible, textarea:focus-visible, .drop:focus-within, .filebtn:focus-within { outline: 3px solid var(--accent); outline-offset: 2px; }
input[type="text"], input[type="search"], input[type="number"], input[type="date"], select, textarea {
  font: inherit; color: var(--ink); background: var(--panel); border: 1px solid var(--line); border-radius: 10px; padding: 7px 10px; min-height: 38px;
}
textarea { width: 100%; font-family: ui-monospace, SFMono-Regular, Menlo, monospace; font-size: .88rem; }

.topbar { display: flex; justify-content: space-between; align-items: center; gap: 12px; padding: 8px 16px; border-bottom: 1px solid var(--line); background: var(--panel); position: sticky; top: 0; z-index: 20; }
.brand { display: flex; align-items: center; gap: 10px; min-width: 0; }
.backlink { font-weight: 700; text-decoration: none; color: var(--ink); }
.appname { color: var(--ink-2); font-weight: 600; white-space: nowrap; }
.freechip { font-size: .78rem; font-weight: 600; padding: 2px 9px; border-radius: 999px; background: var(--panel-2); color: var(--good); border: 1px solid var(--line); }
.topactions { display: flex; align-items: center; gap: 8px; }
.who { font-size: .86rem; color: var(--ink-2); }
.glyphbtn { width: 40px; padding: 0; font-size: 1.1rem; }

main { max-width: 1320px; margin: 0 auto; padding: 0 16px 40px; }
.hero { padding: 26px 0 6px; }
.hero h1 { font-size: clamp(1.7rem, 4vw, 2.5rem); line-height: 1.12; margin: 0 0 10px; letter-spacing: -.015em; }
.lede { font-size: 1.05rem; color: var(--ink-2); max-width: 780px; margin: 0; }
body.loaded .hero { display: none; }

.loader { margin: 18px 0 8px; }
.drop { display: flex; flex-direction: column; align-items: center; justify-content: center; text-align: center; gap: 6px; min-height: 150px; padding: 22px; border: 2px dashed var(--line); border-radius: var(--radius); background: var(--panel); cursor: pointer; transition: border-color .15s, background .15s; }
.drop:hover, .drop.over { border-color: var(--accent); background: var(--panel-2); }
.drop-title { font-size: 1.12rem; font-weight: 600; }
.drop-sub { color: var(--ink-2); font-size: .94rem; }
.loadrow { display: flex; flex-wrap: wrap; gap: 10px; align-items: center; margin-top: 14px; }
.pastebox { margin-top: 12px; display: grid; gap: 8px; justify-items: start; }
.hint { min-height: 1.4em; margin: 10px 0 0; font-size: .92rem; color: var(--ink-2); }
.hint.bad, .note.bad { color: var(--bad); }
.hint.good, .note.good { color: var(--good); }
.hint.warn, .note.warn { color: var(--warn); }
body.loaded .loader { display: none; }

/* --- Workspace --- */
.work { margin-top: 14px; }
.databar { display: flex; justify-content: space-between; align-items: center; gap: 10px; flex-wrap: wrap; }
.dataname { min-width: 0; overflow-wrap: anywhere; }
.dataact { display: flex; gap: 8px; align-items: center; }
.note { margin: 6px 0 0; font-size: .9rem; color: var(--ink-2); }
.ws { display: grid; grid-template-columns: 250px minmax(0, 1fr); gap: 14px; margin-top: 12px; align-items: start; }

.fields { background: var(--panel); border: 1px solid var(--line); border-radius: var(--radius); padding: 12px; position: sticky; top: 64px; max-height: calc(100vh - 80px); overflow: auto; }
.fields input[type="search"] { width: 100%; }
.fields h3 { font-size: .76rem; text-transform: uppercase; letter-spacing: .05em; color: var(--ink-3); margin: 12px 0 6px; }
.fieldlist { display: flex; flex-direction: column; gap: 4px; }
.field { justify-content: flex-start; width: 100%; min-height: 34px; padding: 4px 10px; font-size: .9rem; border-radius: 8px; text-align: left; cursor: grab; border: 1px solid transparent; background: transparent; }
.field:hover { background: var(--panel-2); border-color: var(--line); }
.field .ty { flex: none; width: 22px; height: 18px; border-radius: 5px; font-size: .68rem; font-weight: 700; display: inline-flex; align-items: center; justify-content: center; }
.field.dim .ty { background: var(--dim-bg); color: var(--dim); }
.field.meas .ty { background: var(--meas-bg); color: var(--meas); }
.field .nm { overflow: hidden; text-overflow: ellipsis; white-space: nowrap; min-width: 0; }
.field.calc .nm { font-style: italic; }
.calcbtn { margin-top: 10px; width: 100%; }
.calcbox { display: grid; gap: 4px; margin-top: 8px; }
.calcbox input { width: 100%; }
.fieldhelp { margin: 12px 0 0; }

.stage { min-width: 0; }
.shelves { display: grid; grid-template-columns: 1fr 1fr; gap: 6px; background: var(--panel); border: 1px solid var(--line); border-radius: var(--radius); padding: 10px; }
.shelfrow { grid-column: span 2; display: grid; grid-template-columns: 92px minmax(0, 1fr); align-items: center; gap: 8px; }
.shelfrow.half { grid-column: span 1; }
.shelfname { font-size: .84rem; font-weight: 600; color: var(--ink-2); }
.shelfname small { color: var(--ink-3); font-weight: 500; }
.shelf { min-height: 40px; border: 1.5px dashed var(--line); border-radius: 10px; padding: 3px; display: flex; flex-wrap: wrap; gap: 4px; align-items: center; transition: border-color .12s, background .12s; }
.shelf:empty::before { content: "Drop a field here"; color: var(--ink-3); font-size: .82rem; padding: 0 8px; }
.shelf.over { border-color: var(--accent); background: var(--panel-2); }
.pill { min-height: 32px; padding: 2px 4px 2px 10px; font-size: .86rem; border-radius: 999px; gap: 4px; max-width: 100%; cursor: grab; }
.pill.dim { background: var(--dim-bg); border-color: transparent; color: var(--ink); }
.pill.meas { background: var(--meas-bg); border-color: transparent; color: var(--ink); }
.pill.filter { background: var(--panel-2); }
.pill .pl { overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
.pill .x { width: 24px; height: 24px; min-height: 24px; padding: 0; border-radius: 50%; border: 0; background: transparent; color: var(--ink-2); font-size: 1rem; line-height: 1; }
.pill .x:hover { background: rgba(127,127,127,.18); }

.controls { display: flex; flex-wrap: wrap; justify-content: space-between; gap: 10px; margin: 10px 0 6px; align-items: center; }
.marks { display: inline-flex; flex-wrap: wrap; border: 1px solid var(--line); border-radius: 10px; overflow: hidden; background: var(--panel); }
.mark { border: 0; border-radius: 0; min-height: 36px; padding: 4px 12px; background: transparent; font-size: .88rem; border-right: 1px solid var(--line); }
.mark:last-child { border-right: 0; }
.mark[aria-checked="true"] { background: var(--ink); color: var(--bg); font-weight: 600; }
.mark.shown:not([aria-checked="true"]) { box-shadow: inset 0 -3px 0 var(--accent); }
.opts { display: flex; flex-wrap: wrap; gap: 10px; align-items: center; }
.check { display: inline-flex; gap: 6px; align-items: center; color: var(--ink-2); font-size: .88rem; }
.check input { width: 17px; height: 17px; }
.sel { display: inline-flex; gap: 6px; align-items: center; font-size: .88rem; color: var(--ink-2); }
.sel select { min-height: 34px; padding: 4px 8px; font-size: .88rem; }

.tabs { display: flex; gap: 4px; border-bottom: 1px solid var(--line); margin-top: 6px; }
.tab { border: 0; border-bottom: 3px solid transparent; border-radius: 0; background: transparent; min-height: 38px; font-weight: 600; color: var(--ink-2); }
.tab[aria-selected="true"] { color: var(--ink); border-bottom-color: var(--accent); }
.tabpanel { background: var(--panel); border: 1px solid var(--line); border-top: 0; border-radius: 0 0 var(--radius) var(--radius); padding: 12px; min-height: 300px; }
.why { margin: 0 0 6px; }
.notes { margin: 0 0 8px; padding-left: 18px; color: var(--warn); font-size: .88rem; }
.chartbox { width: 100%; overflow: hidden; }
.chartbox svg { width: 100%; height: auto; display: block; border-radius: 10px; }
.empty { text-align: center; padding: 60px 16px; }
.pivotbox, .tablewrap { overflow: auto; max-height: 640px; border: 1px solid var(--line); border-radius: 10px; }
table.pv, table.dt { border-collapse: separate; border-spacing: 0; font-size: .86rem; font-variant-numeric: tabular-nums; min-width: 100%; }
.pv th, .pv td, .dt th, .dt td { padding: 5px 10px; border-bottom: 1px solid var(--line); white-space: nowrap; text-align: left; }
.pv thead th, .dt thead th { position: sticky; top: 0; background: var(--panel-2); z-index: 1; font-weight: 600; }
.pv thead tr:nth-child(2) th { top: 31px; }
.pv td.num, .dt td.num { text-align: right; }
.pv .ch, .pv .mh { text-align: right; }
.pv .tot { font-weight: 700; }
.pv .rk { font-weight: 500; background: var(--panel); }
.pv .rep { color: transparent; }
.pv .totrow th, .pv .totrow td { border-top: 2px solid var(--line); font-weight: 700; }
.pv .corner { color: var(--ink-3); font-weight: 500; }
.sub { font-size: .9rem; margin: 6px 0; }
.sqlblock { margin: 0 0 12px; }
.sqlblock h4 { margin: 4px 0; font-size: .84rem; color: var(--ink-2); display: flex; justify-content: space-between; align-items: center; gap: 8px; }
.sqlblock pre { margin: 0; padding: 10px 12px; background: var(--panel-2); border-radius: 10px; overflow: auto; font-size: .84rem; line-height: 1.45; white-space: pre; }
.sqlblock .err { color: var(--bad); font-size: .86rem; }

.exportbar { margin-top: 12px; display: grid; gap: 8px; }
.exportbar input[type="text"] { width: 100%; max-width: 520px; }
.saved { margin-top: 16px; background: var(--panel); border: 1px solid var(--line); border-radius: var(--radius); padding: 10px 14px; }
.saved h3 { margin: 0 0 4px; font-size: 1rem; }
.savedlist { list-style: none; margin: 0; padding: 0; display: grid; gap: 6px; }
.savedlist li { display: flex; gap: 8px; align-items: center; justify-content: space-between; border-top: 1px solid var(--line); padding-top: 6px; flex-wrap: wrap; }
.savedlist .meta { font-size: .8rem; color: var(--ink-3); }
.savedlist .acts { display: flex; gap: 6px; }

.menu { position: fixed; z-index: 50; background: var(--panel); border: 1px solid var(--line); border-radius: 12px; box-shadow: 0 8px 30px rgba(0,0,0,.18); padding: 6px; min-width: 200px; max-width: min(320px, calc(100vw - 16px)); max-height: min(440px, calc(100vh - 24px)); overflow: auto; }
.menu h5 { margin: 6px 8px 4px; font-size: .74rem; text-transform: uppercase; letter-spacing: .05em; color: var(--ink-3); }
.menu button.mi { display: flex; width: 100%; justify-content: flex-start; border: 0; background: transparent; min-height: 34px; padding: 4px 10px; font-size: .9rem; border-radius: 8px; }
.menu button.mi:hover, .menu button.mi:focus-visible { background: var(--panel-2); }
.menu button.mi.on::after { content: "\2713"; margin-left: auto; color: var(--accent); }
.menu .fv { display: grid; gap: 6px; padding: 4px 6px; }
.menu .vals { max-height: 220px; overflow: auto; display: grid; gap: 2px; }
.menu .vals label { display: flex; gap: 6px; align-items: center; font-size: .88rem; }
.menu .rng { display: grid; grid-template-columns: 1fr 1fr; gap: 6px; }
.menu .rng input { width: 100%; }
.tip { position: fixed; z-index: 60; pointer-events: none; background: var(--ink); color: var(--bg); padding: 6px 10px; border-radius: 8px; font-size: .82rem; white-space: pre; max-width: 320px; line-height: 1.4; }

.howto { margin-top: 18px; background: var(--panel); border: 1px solid var(--line); border-radius: var(--radius); padding: 6px 18px 12px; }
.howto h2 { font-size: 1.1rem; }
.howto ol { padding-left: 20px; }
.howto li { margin-bottom: 6px; }
.howto summary { cursor: pointer; font-weight: 600; margin-top: 6px; }
.foot { display: flex; gap: 16px; flex-wrap: wrap; justify-content: center; padding: 18px 16px 30px; color: var(--ink-3); font-size: .86rem; }

@media (max-width: 860px) {
  .ws { grid-template-columns: minmax(0, 1fr); }
  .fields { position: static; max-height: none; }
  .fieldlist { flex-direction: row; flex-wrap: wrap; }
  .field { width: auto; border-color: var(--line); background: var(--panel); }
  .fields h3 { margin-top: 8px; }
}
@media (max-width: 560px) {
  .shelfrow, .shelfrow.half { grid-column: span 2; grid-template-columns: 70px minmax(0, 1fr); }
  .appname { display: none; }
  .mark { padding: 4px 9px; }
  .tabpanel { padding: 8px; }
}