I have a dynamic filter (in filter Revenue and Transaction Quantity). When I choose revenue it should change Y Axis £0000 On the bar chart and when I choose Transaction Quantity it should change Y Axis 000 on the bar chart. How could I make this happen please. my code below
parameter: choose_measure {
type: unquoted
allowed_value: {value:"net_amount" label:"Net Amount"}
allowed_value: {value:"total_count" label:"Transaction Quantity"}
default_value: "net_amount"
}
measure: dynamic_measure {
type: number
sql:
{% if choose_measure._parameter_value == 'net_amount' %}
${net_amount}
{% elsif choose_measure._parameter_value == 'total_count' %}
${total_count}
{% else %}
${net_amount}
{% endif %} ;;
}
I ran into the same issue and per chat with Looker support, it doesn’t appear this is currently possible. They referred me to watch a feature request: https://portal.feedback.us.pendo.io/app/#/case/27959
Looks like there are currently no work-arounds.