複数のパラメータを使用したメジャー切り替え

パラメータを２つ使い、メジャーを４種類の集計方法から動的に選んで切り替える例

パラメータ１

合計

平均値

パラメータ２

売上

粗利

code: sample.js

parameter: total_average_filter {

label: "合計・平均値切り替え"

type: unquoted

default_value: "total"

allowed_value: {

label: "合計"

value: "total"

}

allowed_value: {

label: "平均値"

value: "average"

}

}

parameter: sales_profit_filter {

label: "売上・利益切り替え"

type: unquoted

default_value: "sale_price"

allowed_value: {

label: "売上"

value: "sale_price"

}

allowed_value: {

label: "利益"

value: "gross_margin"

}

}

measure: total_or_average {

label: "合計/平均 - 売上/利益"

sql:

{% if total_average_filter._parameter_value == 'total' and sales_profit_filter._parameter_value == 'sale_price' %}

${total_sale_price}

{% elsif total_average_filter._parameter_value == 'average' and sales_profit_filter._parameter_value == 'sale_price' %}

${average_sale_price}

{% elsif total_average_filter._parameter_value == 'total' and sales_profit_filter._parameter_value == 'gross_margin' %}

${total_gross_margin}

{% else %}

${average_gross_margin}

{% endif %}

;;

}