Skip to Content

how to pass parameter to another chart

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Sep 24, 2015 at 08:57 AM

    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.


    111.PNG (13.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 25, 2015 at 12:41 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 24, 2015 at 04:53 AM

    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".

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 24, 2015 at 06:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 25, 2015 at 05:30 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.