Custom Analytics
Build reusable, parameterized analytics with the visual AST builder. Play one to run it (you will be prompted for variables) or trigger it via POST /api/saved-analytics/:id/run.
Create analytic
Query type
Sub-analytics (CTE)
Reuse a saved AST analytic as a named CTE, then set Resource to that CTE to query its result.
Columnsclick to toggle · empty = all (*)
Filters (WHERE)
Modifiers
Window functions
RANK / DENSE_RANK / ROW_NUMBER, or SUM/AVG/COUNT/MIN/MAX OVER (PARTITION BY … ORDER BY …). Computed in-fabric.
Group by
Aggregates
Having (post-aggregate)
Order by
Joins (cross-source, chainable)
Base table is alias
a; joins are b, c, … Reference columns like a.id / b.customer_id.Set operations
Combine the base query with other source/resource legs (columns must line up).
Hierarchy (connect-by)
Function / procedure
Arguments
Variables
Tick "bind" on a filter to turn its value into a
{{variable}}. Variables are prompted at Play time.