Table widget

The table widget renders the query result as rows and columns. It does not ask you to map fields. Whatever the query returns is what the viewer sees.

Use it for detailed lists, mixed text and numbers, or as a debugging view while you design a chart on the same query.

What to show

No field mapping is required. After you run the query, the editor lists how many columns will appear.

Pagination

Pagination is on by default. Rows per page can be 5–100 (default 10). Turn pagination off when the result is short and you want the full list visible in the widget.

Column formatting

Each column can inherit dashboard defaults or use a custom number or date format. That is useful when one column is currency and another is a raw id that should stay unformatted.

Example query

SELECT
  order_id,
  created_at,
  status,
  amount
FROM orders
WHERE account_id = :customer_id
ORDER BY created_at DESC

Related

• Writing queries
• Pivot table when you need grouped totals instead of raw rows