ElegantInsights
Skip to Content
Dashboard BuilderBuild a dashboard

Build a dashboard

Describe a dashboard, shape the plan, let the AI write and test each report's SQL, then add it to Halo.

Last updated on

Building a dashboard takes five steps. Nothing is created in Halo until the last one, and you can leave and come back at any point: your dashboards are listed under the description box, nine most recently edited first. Search by name, or click Show all.

Describe the dashboard

Open Dashboards from the top menu. Type what the dashboard is for and who reads it, or pick one of the ideas under Or start from an idea (click Show ideas if they are hidden). Choose a look, then click Design my dashboard (or press Ctrl + Enter).

Shape the plan

The AI plans a dashboard of tiles, usually in under a minute. Until a tile's report has been tested, it shows made-up figures, hatched and tagged Mockup. Drag and resize tiles, use Add tile, and select a tile to edit it (see Tiles). Tidy layout puts every tile back to its recommended size. In the side panel, Report rules holds what every report follows (see Report rules).

Write the SQL

Connect Halo if you have not, then click Write SQL for N reports. Before the first query, the plan check reads the whole plan and corrects anything that would give a wrong figure, such as an outstanding total and an overdue total counting different invoices. What it changed, and anything it needs you to decide, shows under Plan check in the side panel.

The AI then writes each report and tests it against your Halo data, a few at a time. You can keep editing, or close the page, while it works.

Check each tile

A tile marked Needs attention failed its test. Select it, read the error on the SQL tab and click Ask AI to fix it, or edit the query and click Test and save. The Data tab shows sample rows from your Halo, and the Chat tab lets you ask about one report.

Add it to Halo

Click Add to Halo, check what will be created, and confirm. See Publish to Halo.

What it costs

Planning, the plan check, writing and fixing SQL all use tokens from your allowance. The Tokens section of the side panel shows what the dashboard has used so far and roughly what writing the rest will take. See Understanding tokens.

On this page