I want to know if there is a way to multi select revenue and order count at the same time and see data.
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 %};;
}
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.