Skip to main content
The markdown parameter is not a format value. Use it when you want the data table visualization to render a column as Markdown (for example bold text, links, or images) using a Mustache template filled with each row’s values.
  • format controls standard number, currency, and percentage display for the measure.
  • markdown renders a Mustache template as formatted text (bold, links, images) in table cells.

Syntax

<measure_name>:
  markdown: "<mustache_template>"

Properties

measure_name
object
The name of the measure.

Behavior

  • When you add a measure with markdown to a query and use a Table chart, Omni merges the template into the column’s display settings so cells render as Markdown by default.
  • Mustache can reference {{value}}, {{raw}}, and {{value_url_encoded}} for the current field, and {{view_name.field_name.value}} (and related properties) for other fields in the row.
  • Referenced fields are included in the query automatically when needed.
For how format and markdown interact, see Rich text in data tables on the format page.
Dashboard text tiles and standalone Markdown chart types are separate from field markdown, which applies to workbook data tables for modeled fields.

Examples

Label the aggregated value
measures:
  order_count:
    sql: '"order_id"'
    aggregate_type: count_distinct
    markdown: "**{{value}}** orders"
Link with encoded query parameter
measures:
  revenue:
    sql: '"amount"'
    aggregate_type: sum
    markdown: "[{{value}}](https://example.com/explain?q={{value_url_encoded}})"