Is it possible to have multiple select option for Parameter filter in dynamic measures

Han
Bronze 1
Bronze 1

I want to know if there is a way to multi select revenue and order count at the same time and see data.

Han_0-1703812261848.png

Sample Code:
parameter: measure_selector {
type: unquoted
default_value: "revenue"
allowed_value: {
label: "Order Count"
value: "count"
}
allowed_value: {
label: "Revenue"
value: "revenue"
}
}

measure: dynamic_measure {
label_from_parameter: measure_selector
type: number
sql:
{% if measure_selector._parameter_value == "count" %} ${count}
{% else %} ${total_sale_price}
{% endif %};;
}

@Dawid 

 

0 1 89
1 REPLY 1

If you'd like to select two measures, you would need to create a second parameter "measure_selector_2" and make sure the measure selector performs some kind of "OR" logic. Right now we don't have any kind of parameter that would work with a list of values. 

Alternatively, you could use merge queries where you join two visualisations with different selections but make sure the primary query doesn't have gaps.

Top Labels in this Space
Top Solution Authors