cancel
Showing results for 
Search instead for 
Did you mean: 

how to pass parameter to another chart

former_member202170
Active Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

vijaymuniraj
Active Participant
0 Kudos

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
Active Participant
0 Kudos

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
Active Participant
0 Kudos

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.

Answers (4)

Answers (4)

former_member202170
Active Participant
0 Kudos

thanks guys for all your help

Finally achieved this instance by above is i mentioned the correct answer

and i had done in second way that

i had created two dash boards and linked them by the means of the Bi work space using

portal data connection

provider and consumer connections in the dash board

former_member182541
Active Contributor
0 Kudos

Are you working with live data or with plain excel. If its connection with any DB then you can use a single combo box and then pass the destination to the same to prompts. Else if with the plain excel the above explained method of vijay would be possible option, please check with the mapping it should work perfectly.

former_member183241
Active Participant
0 Kudos

Hi Krishna,

You can use first combo's filtered data for both table and chart. If have any doubt then post details about data so I can guide you how bind both component.

Thanks,

Kashif Khan

Former Member
0 Kudos

Hi krishna,

can you elaborate in detail what you want to show. as I understands from your questions is you used two combo box to filter same thing twice which is "Date".