on 09-23-2015 6:59 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.