Eclipse Community Forums: BIRT » how to compare series in line chart?

Home » Archived » BIRT » how to compare series in line chart?

how to compare series in line chart? [message #1091134]

Wed, 21 August 2013 00:51

Eclipse User

Hi,As a Beginner of birt report .i dont have much knowledge to do report so i have attached a image for u r reference i.e in top i have parameter with check-box to compare year by clicking each option..
for example:
if i click over All of checkbox it have to display line by comparing a year for all data
if i click over classic car of checkbox it have to display line by comparing a year and it have to differentiate year by color too
like wise for all checkbox..
kindly help by providing a sample db its useful to do my report

Attachment: checkbox.jpg
(Size: 30.44KB, Downloaded 266 times)

Re: how to compare series in line chart? [message #1091904 is a reply to message #1091134]

Thu, 22 August 2013 01:06

Eclipse User

One way would be to create all of the combinations of charts and hide/show the appropriate one based on the check boxes. You could also use SVG charts to achieve something like that or a drill through to the report to create the correct chart.

Re: how to compare series in line chart? [message #1092670 is a reply to message #1091904]

Fri, 23 August 2013 00:29

Eclipse User

thank for u r reply can u provide sample db.....

thank in advance..

Re: how to compare series in line chart? [message #1093236 is a reply to message #1092670]

Fri, 23 August 2013 16:01

Eclipse User

What is your BIRT version?

Re: how to compare series in line chart? [message #1093442 is a reply to message #1093236]

Sat, 24 August 2013 00:10

Eclipse User

thank for reply my version is 4.3

thank in advance....

[Updated on: Mon, 26 August 2013 09:27] by Moderator

Re: how to compare series in line chart? [message #1094981 is a reply to message #1093442]

Mon, 26 August 2013 09:28

Eclipse User

i have attached a report for u r reference which i had tried today....but in some case am struggling a lot...
am having two requirement:
1)one is by general report parameter to show line chart
2)and other one is when button click
for instance a if i click button (trend)it show a three checkbox
from this we can select by any combination
for example:
if i click a classic car it show by a line chart by two series(like 2003,2004)
if i click a Train it show by a line chart by two series(like 2003,2004)
and legend label is too change by checkbox...
which i have post previous image ..
kindly provide sample db...
thank in advance....

Attachment: report.rptdesign
(Size: 102.97KB, Downloaded 308 times)

[Updated on: Mon, 26 August 2013 10:25] by Moderator

Re: how to compare series in line chart? [message #1095759 is a reply to message #1094981]

Tue, 27 August 2013 09:44

Eclipse User

kindly reply for this post.....

thank u in advance

Re: how to compare series in line chart? [message #1096231 is a reply to message #1091134]

Wed, 28 August 2013 01:36

Eclipse User

Take a look at this example. It shows the method of creating several charts and hiding/showing them using client-side script based on the check boxes.

Attachment: ChartSeriesByCheckbox.rptdesign
(Size: 272.45KB, Downloaded 264 times)

Re: how to compare series in line chart? [message #1096498 is a reply to message #1096231]

Wed, 28 August 2013 09:22

Eclipse User

first of all very very thank for u r effort....its near by my need.i have attached a report and image for u r reference .again..which i edited slightly for my need
i will explain u clear the one function is missing in that only am struggled alot
for instance:
am having a two condition like:
1)In this report while i select of year parameter it will show a data between a year by line chart
2)other thing is with in report html button is show three check box
when click on check box of classic car it have to display a two Y-SERIES LIKE if i select year (2003-2004)the chart must be like (2003) is in light clour and (2004) is in dark color(dont confuse this report is like a compare year by line chart when click of check box only) again if click of plane check box it have to display a two Y-SERIES LIKE (2003) and (2004) and then legend name to be change of clicking of check box like classic car (2003 is in dark color),classic car (2004 is in dark color)
kindly provide sample db
thank u in advance

Attachment: ChartSeriesByCheckbox.rptdesign
(Size: 301.64KB, Downloaded 245 times)
Attachment: checkbox.jpg
(Size: 33.92KB, Downloaded 213 times)

[Updated on: Wed, 28 August 2013 09:24] by Moderator

Re: how to compare series in line chart? [message #1096621 is a reply to message #1091134]

Wed, 28 August 2013 12:41

Eclipse User

Hopefully this is closer. I'm not sure I'm understanding your image since you're talking about fiscal years. This shows each year of the fiscal year broken into different colors. Let me know if I'm not understanding still.

Attachment: ChartSeriesByCheckbox1.rptdesign
(Size: 277.67KB, Downloaded 344 times)

Re: how to compare series in line chart? [message #1097082 is a reply to message #1096621]

Thu, 29 August 2013 03:56

Eclipse User

thank u effort and reply...yes it is my closer except comparison of line chart.so i have send mail to u(mwilliams_actuate@yahoo.com
mwilliams.actuate@gmail.com) which contain some screenshot for u r reference kindly provide solution...

[Updated on: Thu, 29 August 2013 03:58] by Moderator

Re: how to compare series in line chart? [message #1097456 is a reply to message #1097082]

Thu, 29 August 2013 15:05

Eclipse User

Okay. So, whatever year is there, you just want the previous fiscal year to show as well, for comparison? That should be fairly simple. Let me know and I'll make the changes.

Re: how to compare series in line chart? [message #1097708 is a reply to message #1097456]

Fri, 30 August 2013 00:14

Eclipse User

Thank ...yes u r correct Michael Williams.... if u look at a screenshot they had a some bill,sale,aspd,.and checkbox .etc...according to that it have to drop so if we drop by that legend and tool tips also have to change by that....kindly include a tool tip and legend change according to it....kindly provide sample db

[Updated on: Fri, 30 August 2013 00:16] by Moderator

Re: how to compare series in line chart? [message #1098042 is a reply to message #1097708]

Fri, 30 August 2013 10:22

Eclipse User

With all of these variations, you'll end up with lots of different charts to show/hide. Is doing a drill through okay with you? It will re-run the report each time, but you won't have to create a million different charts. Let me know.

Re: how to compare series in line chart? [message #1098447 is a reply to message #1098042]

Sat, 31 August 2013 00:29

Eclipse User

Sir,but my client requires which are like in screenshot....i cant able to change its ...if u provide as soon as possible it help do my report...

thank u in advance...

[Updated on: Sat, 31 August 2013 02:30] by Moderator

Re: how to compare series in line chart? [message #1099919 is a reply to message #1098447]

Mon, 02 September 2013 07:42

Eclipse User

Kindly reply for this post..

[Updated on: Mon, 02 September 2013 07:42] by Moderator

Re: how to compare series in line chart? [message #1100755 is a reply to message #1099919]

Tue, 03 September 2013 10:54

Eclipse User

Really in need, your absence is annoying me alot.
Hope you will revert back soon..Looking forward!!

Re: how to compare series in line chart? [message #1101082 is a reply to message #1100755]

Tue, 03 September 2013 21:39

Eclipse User

I'm sorry you were annoyed.

You can still have the output like what is shown in your image, you would just reload the report each time vs creating multiple charts and hiding/showing the appropriate one. Let me know if re-loading the report when new choices are made will work or not.

Re: how to compare series in line chart? [message #1101162 is a reply to message #1101082]

Wed, 04 September 2013 00:48

Eclipse User

Is it possible to proivide sample db....and one thing is actually we already spoke about fiscal year...its not a fiscal year.its normal year ..it mean that our financial year start up at (APRIL-2011) and end Up by (MARCH-2012) calculating for one year so if we select (2011-2012) it have to compare a year of (2010-2011) according to screeshot...and then legend have to change by drop parameter(SHOWBY) like Classic Car of BUY-last year and Classic Car of BUY-this year..and tooltip also present...if u seen screenshot u wil understood clearly....
i have attached report which i have tried kindly correct the report..

thank u in advance...

Attachment: Series.rptdesign
(Size: 281.12KB, Downloaded 432 times)

[Updated on: Wed, 04 September 2013 10:24] by Moderator

Re: how to compare series in line chart? [message #1101925 is a reply to message #1091134]

Thu, 05 September 2013 01:31

Eclipse User

I know we already talked about the fiscal year. I understand that part. I showed you how you can hide/show different charts based on client-side script. Adding another set of check boxes for a different feature doesn't change how this is done, it just adds more charts. Here is a design where the year is done how you're expecting. If you do a drill through, you'll just need to pass the selected check box values back to the report via url to report parameters and use them to create the appropriate chart. If you'd like a drill through example, let me know.

Attachment: ChartSeriesByCheckbox1.rptdesign
(Size: 279.55KB, Downloaded 322 times)

Re: how to compare series in line chart? [message #1102217 is a reply to message #1101925]

Thu, 05 September 2013 10:24

Eclipse User

Thank for reply and effort.its helpful but tooltip is missing over on it..Yes it contain many chart.so if u consider a drill through is easy approach.for this report i wil follow that way..kindly provide ..i will look and work on it...
once again thank for a u r effort and patience

[Updated on: Thu, 05 September 2013 10:38] by Moderator

Re: how to compare series in line chart? [message #1102671 is a reply to message #1091134]

Thu, 05 September 2013 21:20

Eclipse User

Here's with the tooltip. I'll work on making you a drill-through example when I have time. I don't have one handy.

Attachment: ChartSeriesByCheckbox1.rptdesign
(Size: 279.65KB, Downloaded 213 times)

Re: how to compare series in line chart? [message #1103220 is a reply to message #1102671]

Fri, 06 September 2013 09:56

Eclipse User

thank for u r reply...and effort...

Re: how to compare series in line chart? [message #1105648 is a reply to message #1091134]

Tue, 10 September 2013 01:43

Eclipse User

Try this report. In the text box at the top of the report, you'll need to switch out the "baseURL" to whatever the base URL is when you first run the report. The current value is what it is when I run the report from my designer. Hope this helps.

Attachment: DrillThroughChartDynamicSeriesAndMeasure.rptdesign
(Size: 55.59KB, Downloaded 335 times)

Re: how to compare series in line chart? [message #1105948 is a reply to message #1105648]

Tue, 10 September 2013 09:35

Eclipse User

thank u very much...i will follow this..method..its so easy...
once again thank u very much for effort....

Re: how to compare series in line chart? [message #1106087 is a reply to message #1105948]

Tue, 10 September 2013 13:18

Eclipse User

Not a problem Let us know whenever you have questions! Smile

Re: how to compare series in line chart? [message #1106788 is a reply to message #1106087]

Wed, 11 September 2013 10:48

Eclipse User

No Message Body

[Updated on: Thu, 12 September 2013 00:49] by Moderator

Re: how to compare series in line chart? [message #1107610 is a reply to message #1106788]

Thu, 12 September 2013 13:24

Eclipse User

Did you have an issue with this? Or is everything working fine? Your most recent message is empty. Let me know.

Re: how to compare series in line chart? [message #1108203 is a reply to message #1107610]

Fri, 13 September 2013 09:48

Eclipse User

Sir i have issue with performance while running the report......i will send u the link by mail.(mwilliams.actuate@gmail.com,mwilliams_actuate@yahoo.com).. u just look on country,zone,state all are cascading parameter...its loading for a long time.......i dono ..wt happens...kindly look on it...report too........i have index the query but also it take a long time...is there possible to debug the report by printing some message ...

thank u in advance...

[Updated on: Wed, 18 September 2013 00:25] by Moderator

Re: how to compare series in line chart? [message #1110666 is a reply to message #1108203]

Tue, 17 September 2013 02:47

Eclipse User

I looked at your link on Friday. It seems to be hanging on the last drop down parameter. You might look there, first.

Previous Topic:	Start WebViewer silently
Next Topic:	Unexpected pageBreak in PDF output

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 17:15:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter