Eclipse Community Forums: BIRT » BIRT CHART : Multiple Dataset on one Y

Home » Archived » BIRT » BIRT CHART : Multiple Dataset on one Y - Axis

BIRT CHART : Multiple Dataset on one Y - Axis [message #805137]

Thu, 23 February 2012 06:25

Eclipse User

I have a problem creating a dynamic chart in BIRT.
The problem statement is as follows:
I have multiple tables stored in sql and user can select any number of tables for comparison on single y axis. X- axis is simply a time stamp. As there can be any number of tables selected so the dataset has to be created dynamically and the number of lines on a line chart will also be decided dynamically.

Please can you guide me how to accomplish the same.

i tried to generate the query dynamically using Java.

Please suggest if there is any other way to using joint statement as the data is huge and cause system to hang while using joint statement.

Regards

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #806295 is a reply to message #805137]

Fri, 24 February 2012 14:52

Eclipse User

Are you currently using the DE API to create the report?

Jason

On 2/23/2012 6:25 AM, Saurabh Puri wrote:
>
> I have a problem creating a dynamic chart in BIRT.
> The problem statement is as follows:
> I have multiple tables stored in sql and user can select any number of
> tables for comparison on single y axis. X- axis is simply a time stamp.
> As there can be any number of tables selected so the dataset has to be
> created dynamically and the number of lines on a line chart will also be
> decided dynamically.
>
> Please can you guide me how to accomplish the same.
>
> i tried to generate the query dynamically using Java.
>
> Please suggest if there is any other way to using joint statement as the
> data is huge and cause system to hang while using joint statement.
>
> Regards

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #806303 is a reply to message #806295]

Fri, 24 February 2012 15:06

Eclipse User

Hi,

Yes i am currently using DE for making report and Chart engine API as well for creating charts.
But i wish to make template or design file and then edit it to display the charts using API.

Also i am confused with the fact whether through API's, i can plot different dataset for different series drawn on a single line chart or can execute different query on different series of Y - axis drawn on single line chart.

Please guide.

Regards

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #807841 is a reply to message #806295]

Sun, 26 February 2012 23:09

Eclipse User

Hi Jason,

Can you please guide for the same... some suggestions for the same will be helpful

Regards

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808492 is a reply to message #807841]

Mon, 27 February 2012 16:03

Eclipse User

Currently the designer only supports attaching one data set to a chart.
You can somewhat get around this by loading up java script arrays on
multiple hidden tables and then in chart script replace the data values,
but this does require some complex scripting. Attached is an example
that shows how to replace the series values using a js array.

Jason

On 2/26/2012 11:09 PM, Saurabh Puri wrote:
> Hi Jason,
>
> Can you please guide for the same... some suggestions for the same will
> be helpful
>
> Regards
>

Attachment: AddJavaSCriptArray.zip
(Size: 6.80KB, Downloaded 256 times)

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808495 is a reply to message #807841]

Mon, 27 February 2012 16:03

Eclipse User

Attachment: AddJavaSCriptArray.zip
(Size: 6.80KB, Downloaded 236 times)

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808499 is a reply to message #807841]

Mon, 27 February 2012 16:03

Eclipse User

Attachment: AddJavaSCriptArray.zip
(Size: 6.80KB, Downloaded 207 times)

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808502 is a reply to message #807841]

Mon, 27 February 2012 16:03

Eclipse User

Attachment: AddJavaSCriptArray.zip
(Size: 6.80KB, Downloaded 272 times)

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #809038 is a reply to message #808502]

Tue, 28 February 2012 07:23

Eclipse User

Hi,

The solution means that I should first create a hidden table where its columns are binded with data from various dataset and then setting the table rows as a global array and then populating the chart series based on this array using a script.

Is the above solution speed efficient as i have data of million lines.
Can i get around by creating a temporary table in sql which store my various selection and then use that temporary table to plot chart.

I think Sql is faster than BIRT engine... Please suggest.

Regards

Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #809581 is a reply to message #809038]

Tue, 28 February 2012 21:32

Eclipse User

I would think doing this with something on the db side would be much
quicker than loading up a bunch of stuff in a js array. I am not sure
how you are going to trigger the creation of the temp table but reading
from it into a new dataset should be simple enough.

Jason

On 2/28/2012 7:23 AM, Saurabh Puri wrote:
> Hi,
>
> The solution means that I should first create a hidden table where its
> columns are binded with data from various dataset and then setting the
> table rows as a global array and then populating the chart series based
> on this array using a script.
>
>
> Is the above solution speed efficient as i have data of million lines.
> Can i get around by creating a temporary table in sql which store my
> various selection and then use that temporary table to plot chart.
>
> I think Sql is faster than BIRT engine... Please suggest.
>
> Regards
>

Previous Topic:	Chart SDK 3.7.2 - suddenly my marker lines and colors gone?!
Next Topic:	Date Formatting Issue

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 15:46:38 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter