how to pass parameter to another chart

[former_member202170]

HI all         

Result set 1:

i had used combo box to filer the date and used the filter data in table

result set 2 :

i had used combo box to filter date and used the filtered data in bar chart

both are working fine

i had used two combo boxes is there any way that i can use only one combo box inset of two

Please advise

Thanks

Krishna M

[vijaymuniraj · Accepted solution]

Krishna,

That is simple and it is question of many dashboard developers. try below steps

1. In your senario, use two combo box as you used now.

2. For first combo box, pass the selected values to destination (for example, if you select country on combo box1 the country name also should be passed to destination, lets assume you passing the selected value to cell A10)

3. Now select second combo box then go to its behavior tab, it will be look like below one.

4. Now set Type as Label and for Item just map it to cell A10 (as mentioned on 2nd step, A10 will be having selected value of first combo box )

5. Now Hide second combo box somewhere behind the layout that customer will not see it.

How it will work: Whenever you select values from 1st combo box then 2nd combo box automatically will get triggered by its label value (If you select country as India, this values will be pass as label for 2nd filter)

Note : Make sure both combo box label values are same.

[former_member202170 · Accepted solution]

Yeah i just did what you have mentioned in the steps the selected value is reflecting in the second combo box that was great

and i had developed a bar char on second combo box when ever there is a change in second combo box the chart has to up date based up on the selection .

Now the chart remain same . if i manually select the values from combo box  then only chart values changing

Please advise is there any thing that i have to up date

Thanks

Krishna M

[vijaymuniraj · Accepted solution]

plz re-map once again the 2nd combo and bar chart and let me know how it works. Also take snapshot of data and check it the values passing to bar chart.