Modeler

Joins and formulas

15–30 min

Relate multiple tables and add calculated fields that become measures or dimensions after publish.

Why it matters

Real metrics often span more than one table or need a calculated expression.

When to use

  • Facts and dimensions live in separate tables.
  • You need a derived metric without writing tile SQL every time.

How to use

  1. Open the model.
  2. Add joins between tables and set keys.
  3. Create formulas in the formula editor using field tokens and catalog functions.
  4. Validate, then publish.

Click path

  1. Tables & lineage for joins.
  2. Formulas panel for calculations.
  3. Prefer model formulas over pasting warehouse-specific SQL into the formula box.

Success check: Joined metrics look sensible and formula fields appear in pickers.

Common mistakes

  • Publishing broken join keys that silently drop rows.
  • Many-to-many joins that duplicate metrics.

Next steps