Combobox

A searchable single-select for a high-cardinality column — type to filter over thousands of customers, SKUs, or users where a plain <Dropdown> (which loads every distinct value) would choke.

Options are fetched server-side as you type: the browser hits /_dashdown/api/options/{query} and the backend runs a SELECT DISTINCT … WHERE col ILIKE '%term%' LIMIT N against the warehouse, so only a small matching page is ever shipped. The picked value lands in filters[name] like every other filter, so your SQL reads it with ${name} and the empty (nothing picked) value trips the all-guard:

SELECT country, downloads
FROM by_country
WHERE '${country}' = '' OR country = '${country}'
ORDER BY downloads DESC

Start typing — the panel lists matching values fetched from the server; pick one and the chart re-queries. The × clears the selection.

The data={query} + column pair names where the distinct values come from. It needn't be the same query the chart shows — point it at a lightweight lookup (SELECT country FROM by_country) and let the heavier display query carry the ${country} guard.

Multi-select #

Add multi to pick several values. They're stored as one comma-joined string that feeds an IN (…) clause — identical to a multi-select <Dropdown>, so the values expand into a quoted, per-item-escaped literal list (empty selection → matches all):

SELECT country, downloads
FROM by_country
WHERE '${countries}' = '' OR country IN (${countries})
ORDER BY downloads DESC

Picks show as removable chips before the search box; the panel marks chosen rows with a ✓ and stays open so you can add several. Backspace on an empty input removes the last chip.