Dashboard page (many charts on one page)

Put many charts on one page, each from its own query, with pickers such as $symbol at the top and an automatic refresh. Dashboards are saved in the database.

• Category: Web console
• Keywords: dashboard, dashboards, Dashboard page, panel, chart panel, text note, Add panel, Add to dashboard, Edit, Variables, $symbol, $from, variable, picker, Auto refresh, refresh, Save, _dashboards, Export JSON, Import JSON, Copy JSON, Duplicate, example dashboards, Market overview, Stock view, Portfolio, today-30d
• See also: Web console, View data page (browse and edit rows), Monitor panel (memory, processor, caches), SELECT, Users and roles

The Dashboard page of the web console (Home menu) shows many charts on one page. Each chart is a panel: one SELECT and the chart settings for it. The panels refresh by themselves, and pickers at the top (a symbol, a date range) change every panel at once.

• A dashboard belongs to the database chosen at the top. It is saved in the table _dashboards of that database, so backups keep it and roles apply.
• The list always holds three example dashboards: Market overview, Stock view and Portfolio. They are made for the sample data. Save on an example makes your own copy.
• A panel only reads: it runs its SQL with GET /exec, which refuses statements that change data. Each panel reads at most 10,000 rows; Rows in its editor picks 100, 1,000, 10,000 or 100,000.

The screen

+---------------------------------------------------------------------------------------------+
| [Stock view v] [Stock view        ]          Auto refresh [30 s v] Refresh Edit Add panel Variables Save More |
| Symbol [CITY v]   From [2025-09-23]   To [2026-09-23]                                        |
| +------------------------------------------------------------+                              |
| | Candles, volume, RSI and MACD                          ... |                              |
| |  (chart)                                                   |                              |
| +------------------------------------------------------------+                              |
| +------------------+ +---------------------------------------+                              |
| | Last close   ... | | Daily move % (calendar)           ... |                              |
+---------------------------------------------------------------------------------------------+

The panels sit on a grid of 12 columns. In Edit mode, drag a panel by its move handle, or drag its bottom right corner to resize it. With the keyboard: arrow keys move it, Shift + arrow keys resize it.

Panels

Each panel has a ... menu:

The panel editor has a title, a kind and, for a chart, the SQL. Chart from SQL is one SELECT and a chart; Text note is a few lines of text, for example how to use the dashboard. Run preview (or Ctrl+Enter) runs the SQL and shows the chart, with the same chart types and settings as the SQL editor.

The quickest way to make a panel: run a query on Home, pick a chart, and click Add to dashboard on the chart bar.

Example: A good panel query: one symbol, a time range (sample data: sample)

SELECT time, open, high, low, close, volume
FROM ochl_day
WHERE symbol = 'CITY'
ORDER BY time;

Result:

(first 5 of 19 rows)

Variables

A variable is a picker at the top of the dashboard. Write $name (or ${name}) in a panel's SQL and the picker's value goes there. Variables opens the list: a name, a label, a type and a default value.

• Text is always quoted, and a ' in it is doubled, so a picker can never change what the statement does.
• A list can allow several values; they go in as 'CITY', 'COAST', for WHERE symbol IN ($symbols).
• $name inside a quoted text or a comment is left alone.
• A value that does not fit its type (a word in a number box) stops the panel with a message; nothing is sent.

Example: What a panel with $symbol, $from and $to runs (sample data: sample)

-- The panel SQL:  ... WHERE symbol = $symbol AND time >= $from AND time < $to
SELECT time, close
FROM ochl_day
WHERE symbol = 'CITY' AND time >= '2025-01-01' AND time < '2026-01-01'
ORDER BY time;

Result:

(4 rows)

Saving, and who may do what

• The first Save in a database runs CREATE TABLE IF NOT EXISTS _dashboards (...). That needs the admin role. A write user who is first is asked to let an admin save one dashboard first, or to use More > Export JSON file.
• A changed dashboard says Changed, not saved next to its title. Opening another one first asks whether to drop the changes.
• Export JSON file and Import JSON move a dashboard to another database or another server. An imported dashboard opens at once; Save keeps it.

Example: The table the first Save creates

CREATE TABLE IF NOT EXISTS _dashboards (id STRING PRIMARY KEY, title STRING NOT NULL, body STRING NOT NULL, updated TIMESTAMP, updated_by STRING);
SHOW COLUMNS FROM _dashboards;

Result:

CREATE TABLE IF NOT EXISTS _dashboards (

table '_dashboards' created

SHOW COLUMNS FROM _dashboards

(5 rows)