Charts by Sales Area

[Former Member]

Dear Gurus,

I have a problem in visual composer.

I have created a model that has a selection list (sales area) and 2 charts.

Initially the charts shows the total sales per month.

But my requirement is to select (double click) different sales area from the list and get the corresponding charts (by sales area).

The problem here is when I double click any particular sales area the charts don't get changed. They keep on showing the total results.

Please reply me ASAP.

Thanks, Akash

[Former Member · Accepted solution]

Hi Akash,

You can use 'filter' to get the details only for particular sales area and pass it to the chart. Use select event for table to get the sales area for filter and according to this make the condition in filter.

Regards

Basheer

[Former Member · Accepted solution]

Thanks Basheer for your reply.

I did actually fix that problem before.

But now I have another problem.

If you give me some idea ??

The selection table is now working fine, but I can't see the charts for the Total value.

I mean by default it selects the first row and shows the charts for its value.

But I want the initial screen to show me the charts for TOTAL value for all Sales Area.

How that can be done.

Please let me know if I'm not clear.

Thanks.

[Former Member · Accepted solution]

Akash,

If you passing inputs to chart from table( means drag a chart from table) it will show all the rows in chart. Don't set any event form table to chart.

Regards

Basheer

[Former Member · Accepted solution]

Yes, thats true.

But I need to have both option at the same time.

How do I do that ?

[Former Member · Accepted solution]

Use two tables(one for general another for sales area selection) and make the one(general) as invisible but its chart will be visible. Here you can achieve this.

Regards

Basheer

[Former Member · Accepted solution]

Good Idea.

So you are suggesting is I will have another table from start input and the output of the table will go to all the charts with NO EVENT.

Right ??

Well, I can do that but

1) How can I make that table invisible ?

2) Also by default the first row of the second table (with event) will get selected. So again the charts will get changed in a second, Isn't it ?

[Former Member · Accepted solution]

The output of the new table will go only for the chart which contains all data. The another chart(for seperate sales area) will get input from previous table and no change in this. To change its visibility set 'Visible=false' in the 'configure element' window.

[Former Member · Accepted solution]

I can't link the output of the invisible table with the chart directly.

It's not letting me connect that.

[Former Member · Accepted solution]

Okay. Make the table as visible and overlap it with the another table in design time. So it will not visible in run time bcoz it will be in behind of the another table.

[Former Member · Accepted solution]

In this case will it show the result of the invisible table by default ?

Can you please explain a bit further ??

Edited by: Akash bw on Feb 18, 2009 2:23 AM

[Former Member]

Thanks guys

[Former Member]

any input ??