Query, reports & dashboards
Ask your data anything
Every record you create is queryable three ways — a structured query language, full-text search, and an analytics pipeline on a columnar engine. Wrap the answers in dashboards with 40+ chart types, or just ask in plain English.
SOQL
A real query language over your objects
SELECT with aliases, dotted parent paths, parent-to-child subqueries and aggregates; WHERE with the full operator set; GROUP BY, HAVING, ORDER BY, cursor pagination — compiled to native database pipelines with your permissions injected automatically. Even geospatial: DISTANCE and GEOLOCATION are built in.
- COUNT, COUNT_DISTINCT, SUM, AVG, MIN, MAX
- Subqueries and parent-path joins
- Computed fields inlined at query time
- explain, count-only and parse-only modes
SELECT brand, COUNT(Id), SUM(total_amount)
FROM reservation
WHERE reservation_status IN ('Confirmed', 'Checked In')
GROUP BY brand
ORDER BY SUM(total_amount) DESC
LIMIT 10Search + natural language
Type English. Or SOSL. Both work.
The global search box accepts raw SOQL, full-text SOSL FIND queries scoped to names, emails or phones, SAQL pipelines — or a plain question. Natural-language input is translated to the right dialect, so 'reservations checking in this week in Cancun' just works.
- Federated full-text search across every object, ACL-scoped
- NAME / EMAIL / PHONE / ALL search scopes
- Natural-language → SOQL/SOSL/SAQL translation
- Feature data (tasks, products, posts…) searchable too
Reports
Build reports visually — or write raw SAQL
Pick a source, choose columns, group, aggregate, filter, sort, chart. Or drop into SAQL — a pipeline DSL with load, filter, group, foreach, timeseries and cogroup verbs — compiled to ClickHouse for columnar speed. AI suggests reports from your schema you can accept in one click.
- Table, chart, or combined view per report
- SAQL verbs incl. union, cogroup, timeseries
- Aggregates from count to percentile and stddev
- AI report suggestions, generated and validated
Dashboards
40+ chart types on a drag-anywhere canvas
Dashboards are grids of lenses — each lens a saved report rendered as a chart. Drag-select a region to place one. The chart library spans the practical and the exotic, with a recommendation engine that suggests the right visualization from the shape of your data.
- KPI, gauge, funnel, waterfall for the operators
- Sankey, chord, network, treemap for the analysts
- Calendar heatmaps, Gantt, timelines for the planners
- Point, hex and geo maps for the field
The chart library
Under the hood
Columnar mirror
Every org is mirrored to ClickHouse — one wide table per org, synced on write.
Typesense search
Full-text search index with ACL filtering and regex fallback.
Visibility injection
Record-level permissions are compiled into every query — no leaky reports.
Chart recommendations
The engine suggests a chart type from your result's shape.
Query envelope
Results carry columns, totals, cursors, warnings, timing and the parsed AST.
Explain mode
?explain=1 shows the compiled plan for debugging.
Works better together
Related modules
Run your whole business from one tab.
Join the early access — bring your team, connect your channels, and keep every workflow in one place.