Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » how to compare series in line chart?
how to compare series in line chart? [message #1091134] Wed, 21 August 2013 04:51 Go to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 234 times)
Re: how to compare series in line chart? [message #1091904 is a reply to message #1091134] Thu, 22 August 2013 05:06 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1092670 is a reply to message #1091904] Fri, 23 August 2013 04:29 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 20:01 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

What is your BIRT version?

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1093442 is a reply to message #1093236] Sat, 24 August 2013 04:10 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
thank for reply my version is 4.3

thank in advance....

[Updated on: Mon, 26 August 2013 13:27]

Report message to a moderator

Re: how to compare series in line chart? [message #1094981 is a reply to message #1093442] Mon, 26 August 2013 13:28 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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....

[Updated on: Mon, 26 August 2013 14:25]

Report message to a moderator

Re: how to compare series in line chart? [message #1095759 is a reply to message #1094981] Tue, 27 August 2013 13:44 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 05:36 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1096498 is a reply to message #1096231] Wed, 28 August 2013 13:22 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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





[Updated on: Wed, 28 August 2013 13:24]

Report message to a moderator

Re: how to compare series in line chart? [message #1096621 is a reply to message #1091134] Wed, 28 August 2013 16:41 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1097082 is a reply to message #1096621] Thu, 29 August 2013 07:56 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 07:58]

Report message to a moderator

Re: how to compare series in line chart? [message #1097456 is a reply to message #1097082] Thu, 29 August 2013 19:05 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1097708 is a reply to message #1097456] Fri, 30 August 2013 04:14 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 04:16]

Report message to a moderator

Re: how to compare series in line chart? [message #1098042 is a reply to message #1097708] Fri, 30 August 2013 14:22 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1098447 is a reply to message #1098042] Sat, 31 August 2013 04:29 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 06:30]

Report message to a moderator

Re: how to compare series in line chart? [message #1099919 is a reply to message #1098447] Mon, 02 September 2013 11:42 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
Kindly reply for this post..

[Updated on: Mon, 02 September 2013 11:42]

Report message to a moderator

Re: how to compare series in line chart? [message #1100755 is a reply to message #1099919] Tue, 03 September 2013 14:54 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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] Wed, 04 September 2013 01:39 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.


Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1101162 is a reply to message #1101082] Wed, 04 September 2013 04:48 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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...

[Updated on: Wed, 04 September 2013 14:24]

Report message to a moderator

Re: how to compare series in line chart? [message #1101925 is a reply to message #1091134] Thu, 05 September 2013 05:31 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.



Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1102217 is a reply to message #1101925] Thu, 05 September 2013 14:24 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 14:38]

Report message to a moderator

Re: how to compare series in line chart? [message #1102671 is a reply to message #1091134] Fri, 06 September 2013 01:20 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1103220 is a reply to message #1102671] Fri, 06 September 2013 13:56 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 05:43 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.



Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1105948 is a reply to message #1105648] Tue, 10 September 2013 13:35 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 17:18 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1106788 is a reply to message #1106087] Wed, 11 September 2013 14:48 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
No Message Body

[Updated on: Thu, 12 September 2013 04:49]

Report message to a moderator

Re: how to compare series in line chart? [message #1107610 is a reply to message #1106788] Thu, 12 September 2013 17:24 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
Re: how to compare series in line chart? [message #1108203 is a reply to message #1107610] Fri, 13 September 2013 13:48 Go to previous messageGo to next message
sumi v is currently offline sumi vFriend
Messages: 23
Registered: August 2013
Junior Member
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 04:25]

Report message to a moderator

Re: how to compare series in line chart? [message #1110666 is a reply to message #1108203] Tue, 17 September 2013 06:47 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
Previous Topic:Start WebViewer silently
Next Topic:Unexpected pageBreak in PDF output
Goto Forum:
  


Current Time: Thu Mar 28 18:16:01 GMT 2024

Powered by FUDForum. Page generated in 0.04878 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top