Key results are the primary outputs of a Compass session — specific query results that have been given a title, description, and optional chart visualization.
How Key Results Are Created
Every successful database query in a session is stored as a potential key result. The AI can use the PROMOTE_RESULT tool to give a query result a title, description, and optional chart configuration, which surfaces it in the Key Results pane.
Editing Key Results
Session owners can edit key results using the Edit button on each result card. Editable fields include:
- Title and Description — Describe what the result shows.
- Chart configuration — Add or modify a chart visualization.
- Default Presentation — Choose whether to show the chart, table, or both by default.
Key results can also be removed, which clears the title and description but retains the underlying query data.
Data Integrity
Results presented in the main conversation panel are generated by the LLM and carry the inherent risk of hallucination — the AI may summarize, round, or fabricate numbers in its narrative responses.
Key results, by contrast, provide a layer of data integrity:
- Data tables contain the exact response returned by the database for the given SQL query. Compass stores and displays these results directly, with no LLM intermediation. That said, the SQL itself is AI-generated and may contain logical errors, so users should always review the query to confirm it answers the intended question correctly.
- Charts are hallucination-free visualizations rendered directly from the data table. The LLM's role is limited to choosing which fields to chart and which chart type to use when it promotes a result — the plotted values are always drawn straight from the underlying data.
This design means that while the conversational narrative should be treated as interpretive guidance, the key results panel is the authoritative source for verified query output.
Charts and Visualizations
Four chart types are supported:
- Bar — Category-based bar charts with up to 2 measure columns.
- Timeseries — Line charts over time, with optional dimension grouping for multiple lines.
- Scatter — Two-variable scatter plots with optional point labels.
- Single Value — A single prominent number or value, suitable for KPIs.