Tiles
Edit a tile on a Dashboard Builder dashboard, from its type and chart to the brief its SQL is written from.
Last updated on
Select a tile to open its editor beside the dashboard. It has four tabs: Tile, Chat, Data and SQL. Changes on the Tile tab are a draft until you click Save, and the dashboard shows them as you go.
Name
The tile's title in Halo. A section tile has a Heading instead.
Shows as
A report tile is a Counter, a Chart or a Table. Switching keeps its SQL. Section tiles, which only hold a heading, are added with Add tile.
Charts
Pick the chart type, then the column for its Categories and the one for its Values. Once the SQL has been tested, both list the columns it returned. A multi-series chart plots one line per column you pick under Lines, or every value column if you pick none.
The plan decides whether a chart counts records or totals a value. A chart that ranks customers, agents or items, such as "Top 10 customers by revenue", is sorted by value and shows the top 10 in Halo. Other bar charts keep their categories in order, so age bands read oldest to newest, and line and area charts run in date order.
Counters
Counts is what the number is: count the records, or sum or average a column. To sum or average, pick the Column, and whether it is shown as a Number or as Money.
Colour
Counters and sections can have their own colour. With the Elegant look, a counter's colour can be its number or a fill for the whole widget. With None it is the number. Use default removes it.
What this report shows
The brief the SQL is written from: which records, by which date, in which state. If you change it after the SQL is written, the tile offers Rewrite the SQL. When the AI rewrites the brief for you (leave the brief empty when you rename a tile from its hover menu), it is a new report, so its old SQL is cleared and Continue writes it again.
Columns it should return
The columns the report must return. Type a name and press Enter to add one, or remove one with its cross. Every report also returns the dashboard's filters.
The Chat, Data and SQL tabs
These tabs widen the panel. Click Expand to give them half the screen.
- Chat is a conversation about this one report. It is saved in your chat history too.
- Data loads sample rows from your Halo data.
- SQL shows the query. Click Edit SQL to change it in a wide editor, then Test and save, or click Ask AI to fix it when a test fails. When a rule or check proposes a change, it shows here to accept or keep the current query. Saving a change to a report already in Halo marks it changed until you publish again.