Conditionally formatting measures selected from parameters (Community)

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 %} ;;