OneAnalytics docs

Build a dashboard

A dashboard in OneAnalytics is a named collection of visuals that share a dataset, a set of filters, and a canvas. Open any dataset and click New dashboard to get started. (In the UI and API this asset is typed as report — the two words are interchangeable in OneAnalytics.)

Canvas basics

  • Infinite canvas, scrolls in both directions
  • 8-column responsive grid on desktop, 1-column stack on mobile
  • Visuals snap to grid; resize by dragging the lower-right corner
  • Zoom from 50 % to 200 %; zoom state persists per user, not per artefact

Filters

Top-level filters sit at the top of the canvas; per-visual filters attach to a single visual. Filters compose:

  1. Dataset-level filters (from the semantic model security rules)
  2. Canvas filters
  3. Visual filters

A query is always the intersection. Every filter is visible in the visual's Details panel and in the sql_preview.

Filter operators: =, !=, in, not in, between, contains, starts_with, ends_with, is_null, is_not_null. Date filters also support today(), yesterday(), last_n(days, 7), and relative ranges.

Drilldowns

Right-click any data point and choose Drill down. OneAnalytics picks the next dimension in the hierarchy (country → state → city) and re-queries. Click back to undo.

Drillthrough via right-click opens another canvas with the clicked context (dimension values) pre-filtered.

Bookmarks

A bookmark is a saved state — filters, sorts, visuals shown/hidden, drill level. Share a bookmark URL and the recipient lands in exactly the state you captured, if they have access.

Parameters

Parameters are named, typed inputs that the viewer can change without touching filters directly. Great for what-if analysis:

param discount_pct: number, default 5, min 0, max 50
measure adjusted_revenue = revenue * (1 - [discount_pct] / 100)

A slider appears on the canvas; dragging it re-runs the queries.

Performance

  • Every visual is its own query; we parallelise up to 8 in flight.
  • Results are cached for 5 minutes per (dataset version, query hash, RLS-bound user attributes).
  • The Refresh cache button in the top-right forces re-execution.

Export

From the ... menu on any visual or on the whole canvas: export to PDF, Excel, CSV, JSON, Parquet, PNG, PPTX, SQL. See Export for the full matrix.