Skip to main content

Dynamic Variables

Omni content can be made more dynamic by using the Mustache syntax to insert variables in different areas of the product - text tiles, dashboard titles, axis labels, and many more. Dynamic sections can read in variables like filters used, and do basic lookups into the query payload.

Here are a few examples (text tiles showing filters, axis with summary stats that shows filters):

Text Tiles​

From the dashboard text tiles can be made to dynamically reference filters that have been selected:

## Breakdown by Country
Filter applied: country **{{}}**
# Breakdown by state
Filter applied: state **{{filters.users.state.summary}}**

KPIs and Markdown Visualizations​

Markdown visualizations (in the workbook) can be wired to reference specific values in the table, as well the filters via the rows returned:

There have been **{{result._totals._first.order_items.order_count.value}}** orders placed for **{{result._first.products.brand.value}}** in **{{result._first.users.state.value}}**, and the average selling price is **{{result._first.order_items.sale_price_average.value}}**. 

See the πŸ—ΊπŸ“ below for **{{result._first.products.brand.value}}** stores in the top selling city - **{{}}, {{result._first.users.state.value}}**.

Iframes (via Markdown Visualization)​

Similar to vanilla markdown tiles, iframes can be made dynamic as well, here using a Google Maps search with a dynamic URL:

<iframe src="{{result.0.products.brand.value_static}}+in+{{}},{{result._first.users.state.value_static}}&key=AIzaSyCXfF4zpXaYkgVaBzj3oZUtmcDAxpdoOGk&" width="100%" height="100%" style="border:0;" allowfullscreen="" loading="lazy" referrerpolicy="no-referrer-when-downgrade"></iframe>

Visualization Axis Labels​

Visualizations can also be made dynamic, here in the y-axis label to show summary values and the filter objects:

Order Count ({{result._totals.0.order_items.order_count.value}} Total Orders in {{result.0.users.state.value}})

HTML Escaping​

When using the {{ variable }} syntax, all variables are HTML escaped by default. If you want to return raw contents without escaping, use the triple mustache, ie. {{{ variable }}}.

For more specifics on syntax and gotchas, see the Mustache docs.

Markdown Syntax Reference​

These mirror references in Markdown blocks

Part of the queryElementExample SyntaxExample Output
FieldView name{{fields.order_items.sale_price_sum.view_label}}Order Items
FieldField name{{fields.order_items.sale_price_sum.label}}Sale Price Sum
FieldFirst row value{{result._first.Female.order_items.sale_price_sum.value}}$21.60K
FieldLast row value{{result._last.Female.order_items.sale_price_sum.value}}$28.82K
FieldAny row value (array syntax starting with 0){{result.5.Female.order_items.sale_price_sum.value}}$31.29K
FieldColumn total{{result.totals._first.Female.order_items.sale_price_sum.value}}$870.97K
FieldRow total (array syntax starting with 0){{result.5.row_total.order_items.sale_price_sum.value}}$62.87K
FieldGrand total{{result.totals._first.row_total.order_items.sale_price_sum.value}}$1.63M
FiltersSummary{{filters.users.state.summary}}is: California,Virginia

* Note: There are two options for returning the field value: .value will return an interactive value where drilling is enabled, .value_static will return just the raw value with no interactivity.