Interactive Playground

Experiment with TPLm queries in your browser. All queries run locally using DuckDB WASM with a sample employment survey dataset.

Query Editor

Write your TPL query and click Run to see results:

TPL Query

TABLE ROWS occupation[5] * income.sum COLS education;

Dataset:samplesoccupation, education, gender, income

Dimension Definitions

Expand this section to view or customize the computed dimensions. Changes apply to all queries on this page.

▶Dimension Definitions

Define computed dimensions using Malloy's pick syntax. Dimensions sort by declaration order (the order picks are listed).

Definition Order

Notice how occupation[5] returns the first 5 occupations by definition order (Managerial, Professional, Technical...) rather than alphabetically. TPL automatically detects pick expressions and sorts by declaration order.

More Examples

Simple Table

TABLE ROWS occupation * income.sum;

Dataset:samplesoccupation, education, gender, income

Basic Crosstab

TABLE ROWS occupation * income.sum COLS education;

Dataset:samplesoccupation, education, gender, income

Advanced Example

TABLE
  ROWS occupation[-5@income.sum] * (gender | ALL) * income.(sum | mean)
  COLS education | ALL;

Dataset:samplesoccupation, education, gender, income

Quick Reference

Basic Structure

TABLE [FROM source] [WHERE condition]
      ROWS <row-axis>
      [COLS <column-axis>];

Common Patterns

Nesting (*)

-- Each state contains cities
state * city

Concatenation (|)

-- State section followed by gender section
state | gender

Totals (ALL)

-- Row with total
(state | ALL)

-- Column with total
COLS year | ALL

Limits and Ordering

-- Top 10 by value
state[-10@births.sum]

-- Bottom 5 alphabetically
state[5]

Percentages (ACROSS)

-- Row percentages (each row sums to 100%)
income.sum ACROSS COLS

-- Column percentages
income.sum ACROSS ROWS

-- Cell percentages
income.sum ACROSS

More Examples

Explore categorized examples in the sidebar:

• Core Concepts - Basic building blocks
• Totals - Marginals and subtotals
• Limits - Top N and ordering
• Percentages - Ratio calculations
• Advanced - Complex patterns