LinkedIn
Twitter
How can I dynamically change the value format of the Y axis when the selection for the Y axis is made on the basis of the parameter value selected?
parameter: Select_KPI {
type: unquoted
#default_value: "total_Sales"
allowed_value: {
label: "Sale Price"
value: "total_Sales"
}
allowed_value: {
label: "Profit"
value: "profit"
}
allowed_value: {
label: "Profit Margin"
value: "profit_margin"
}
allowed_value: {
label: "Quantity"
value: "total_order_quantity"
}
allowed_value: {
label: "Sales Per Customer"
value: "sales_per_customer"
}
allowed_value: {
label: "Average Order Value"
value: "average_order_value"
}
allowed_value: {
label: "Cost"
value: "cost"
}
}
This is the parameter I have created. I have defined the value format for each measure independently but that is not working when I select that measure through parameter.
