View the original community article here
Last tested: Mar 17, 2021
If you have a parameter like so:parameter: labor_type_parameter {
type: string
allowed_value: { value: "Hours" }
allowed_value: { value: "Headcount" }
}
Where hours and headcount are defined like so:measure: hours {
type: sum
sql: (${test} / 60.0) ;;
value_format: "#,##0.00"
}
measure: headcount{
type:average
sql: (${test} / 10.0) ;;
value_format: "#,#
#0
"
}
You can create a measure that has html like so to conditionally format based off of parameter selection. NOTE: this will not affect the visualization, only the data table.html: {% if labor_type_parameter._parameter_value == "'Hours'" %}
{{ hours._rendered_value }}
{% else %}
{{ headcount._rendered_value }}
{% endif %} ;;
This content is subject to limited support.