View the original community article here
Last tested: Jan 21, 2019
Yes, you can do this using the assign
Liquid syntax. For example:
filter: filter_value_to_pass {
type: number
}
measure: my_measure {
type: sum
sql: ${TABLE}.field;;
html: {% assign var=_filters['filter_value_to_pass'] | plus: 0 %}
{% if value < var %}
<div style="color: blue">{{ value }}</div>
{% else %}
<div style="color: orange">{{ value }}</div>
{% endif %} ;;
}
Where | plus: 0
casts the var
value from String to Integer. You could could also use | times: 1
.
…
html: {% assign var=_filters['filter_value_to_pass'] | times: 1 %}
...
This content is subject to limited support.