Mustache cheatsheet

For detailed information, refer to the Mustache syntax reference.

Query metadata

Returns query metadata. Supported only in dashboard Markdown tiles.

Returns	Syntax
Query name	`{{queries.query_id.name}}`
Query subtitle	`{{queries.query_id.subtitle}}`
Query description	`{{queries.query_id.description}}`
Query topic name	`{{queries.query_id.topicName}}`
Query created at	`{{queries.query_id.createdAt}}`
Query updated at	`{{queries.query_id.updatedAt}}`

Query fields

Returns metadata about a query field. Supported in Markdown visualizations.

Returns	Syntax
View name	`{{fields.view_name.field_name.view_label}}`
Field name	`{{fields.view_name.field_name.label}}`
Field description	`{{fields.view_name.field_name.description}}`

Query results

Returns a value from query results. Supported in Markdown visualizations.

Returns	Syntax
First row	`{{result._first.view_name.field_name.value_type}}`
Last row	`{{result._last.view_name.field_name.value_type}}`
Specific row	`{{result.row_number.view_name.field_name.value_type}}`
Column total	`{{result._total.first.view_name.field_name.value_type}}`
Row total	`{{result.row_number.row_total.view_name.field_name.value_type}}`
Grand total	`{{result.totals._first.row_total.view_name.field_name.value_type}}`
Pivot column iteration	`{{#result._pivots}}...{{/result._pivots}}`
Pivot row iteration	`{{#row._pivots}}...{{/row._pivots}}`

Value types: value (interactive), value_static (formatted), raw (plain)

Filters

Returns metadata about filters. Supported in Markdown tiles.

Dashboard filters use the filter ID:

Returns	Syntax
Label	`{{filters.filter_id.label}}`
Summary	`{{filters.filter_id.summary}}`
Value	`{{filters.filter_id.value}}`
URL-encoded value	`{{filters.filter_id.value_url_encoded}}`
JSON	`{{filters.filter_id.json}}`

Workbook filters use the view and field name:

Returns	Syntax
Label	`{{filters.view_name.field_name.label}}`
Summary	`{{filters.view_name.field_name.summary}}`
Value	`{{filters.view_name.field_name.value}}`
URL-encoded value	`{{filters.view_name.field_name.value_url_encoded}}`
JSON	`{{filters.view_name.field_name.json}}`

Controls

Returns metadata about dashboard controls. Supported in Markdown tiles.

Returns	Syntax
Label	`{{controls.control_id.label}}`
Summary	`{{controls.control_id.summary}}`
Value	`{{controls.control_id.value}}`
URL-encoded value	`{{controls.control_id.value_url_encoded}}`
JSON	`{{controls.control_id.json}}`

Dashboard metadata

Returns dashboard metadata. Supported in Markdown tiles.