Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I add a selection dropdown to choose from a list of Measures and auto-plot a chart or table that list all products that meet this selected Measure?
Hi ThamCW
You have some options to achieve the chart
1) Using Alternative Measures on chart: You can use a chart (Bar, line or combo) and assign the dimension (Product) and one measure, the extra measures you can add on Alternative Measures. When you close the editor mode you can select the desired measure on chart
2) Using Variable Input extension and chart: You can create variables (one per each measure) , each variable will be defined with measure expression also you need one variable extra that will be used on variable input extension, you can call vSelectedMeasure. On variable input extension choose the list mode and use the vSelectedMeasure variable, define the values (one per each measure) . On chart (table, bar, line or whatever) select your dimention (Product) and on you measure try to use an expression that evaluate the selected measure on vSelectedMeasure variable and then choose the variable measure, one option is a if sentence