Text

Display rich text with embedded data values from your queries

Displays rich text with embedded data values. Use {{column_name}} to inject query results into your text.

SQL Shape

Any columns. Only the first row is used for variable substitution.

SQL

SELECT name, revenue, region FROM top_customer LIMIT 1

Content Example

Top customer: {{name}}
Revenue: ${{revenue}}
Region: {{region}}

Computed Values

You can use basic math expressions inside {{}}:

Revenue (thousands): ${{revenue / 1000}}
Margin: {{(revenue - cost) / revenue * 100}}%
Average: {{total / count}}

Supported operators: +, -, *, /, and parentheses. Column names in expressions are substituted with their numeric values from the query result.

If you need more complex computation (rounding, string functions, conditionals), do it in SQL:

SQL

SELECT
  name,
  revenue,
  ROUND(revenue / 1000.0, 1) AS revenue_k,
  ROUND((revenue - cost) / revenue * 100, 1) AS margin_pct
FROM summary LIMIT 1

Then reference the computed columns directly: Revenue: ${{revenue_k}}k

Editor

The text editor renders {{variables}} as colored pills:

Blue pill: valid column name from your query
Violet pill: expression (contains operators like +, /)
Gray pill: unrecognized column name

Click a column chip below the editor to insert it at the cursor.

Options

Option	Description
Background	Pick from 14 gradient colors

Conditional Display