Live dashboards
Build dashboards from SQL in RowDex: add widgets as charts, numbers or tables, refresh them automatically and arrange them per connection.
A dashboard is a set of widgets, and every widget is a SQL query shown as a chart, a number or a table. It reads straight from your live connection, so there is no CSV export and nothing to go stale.
Screenshot placeholder
A RowDex dashboard with a line chart of signups, a pie chart of order status, and three single-number widgets.
public/docs/dashboard-overview.pngCreate a dashboard#
Open the dashboard view
Connect to a database, then switch the workspace from SQL to Dashboard. Dashboards belong to the connection shown as the Data source.
Name it
Enter a name under New dashboard name and create it. You can rename or delete it later.
Add a widget
Click Add widget. Give it a title, paste the SQL, choose how it looks and how often it refreshes, and save.
Screenshot placeholder
The Add widget dialog with a title, a SQL box, a chart type picker and a refresh interval.
public/docs/dashboard-add-widget.png
Choose a visualization#
| Type | Use it for |
|---|---|
| Metric (number) | A single KPI, such as total orders today. |
| Line | A trend over time, such as daily signups. |
| Area | A trend where volume matters, such as requests per hour. |
| Bar | Comparing categories, such as revenue by country. |
| Pie | A breakdown of a whole, such as orders by status. |
| Table | A list you want to read row by row. |
For charts, pick which result column supplies the labels (the X axis) and which columns supply the values. For a pie chart, choose the label and the value column. The preview updates as you choose.
Refresh#
- Set a refresh interval on each widget. The minimum is 10 seconds.
- Switch the dashboard between Manual and Auto. In Auto, widgets refresh on their own interval. In Manual, click Run all widgets or refresh a single widget.
- A widget whose query fails shows the error on the card, so one bad query never hides the others.
Work with widgets#
- Drag a widget by its handle to move it.
- View SQL to see the query behind a card.
- Fullscreen a widget for a closer look.
- Edit to change the query, type, color or refresh interval, or Delete to remove it.
Was this page helpful?