Skip to Content
author's profile photo Former Member
Former Member

Dynamic refresh of chart by selecting a table row

Hello All

I have a VC model with a BI query as a dataservice and table and chart as the output. The business need is that when a user clicks on a row on the table the chart should also get refreshed with the related row data.Currently the chart only shows the data in the first row of the table.I have read forums and tried solutions recommended like including the dataservice twice and connecting the output of the table to the input of the second dataservice and connecting its output to a chart but it still does not work. If anybody has found a workable solution can you please share?.

Thanks

Nirmala

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 04, 2008 at 04:18 PM

    Hi,

    instead of using the "submit" button, use the "select" event name on the line between your table and your chart.

    Fabien.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 04, 2008 at 05:12 PM

    fabien thanks for the reply but what you are suggesting is not relevant as I do not have a "submit" currently between my table and the chart. The output of the table to the chart does not let me write an event inorder for me to write a select instead of submit.

    Thanks

    Nirmala

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 04, 2008 at 05:29 PM

    Currently I do have my chart after my table and the output of the table is connected to the input of the chart

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      The Signal In/Out approach for transfering a selected table row to a chart does indeed work as described in this post. However, in this case, each column of the row is treated as a separate data series by Visual Composer. So, for example, if the table contains 12 columns, one for each month of the year, you end up with 12 separate data series, each with only one data element corresponding to the item in the selected row. In situations like this the requirement typically is to show the whole row as a single data series on the chart, rather than 12 separate data series.

      I would be interested to know if anyone has a solution to this problem.

      Thanks,

      Mustafa.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 12:45 PM

    Hi, Can you send me the screenshots to me?

    Thanks!

    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.