|
Re: how to compare series in line chart? [message #1091904 is a reply to message #1091134] |
Thu, 22 August 2013 05:06 |
|
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 #1094981 is a reply to message #1093442] |
Mon, 26 August 2013 13:28 |
sumi v 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 #1096498 is a reply to message #1096231] |
Wed, 28 August 2013 13:22 |
sumi v 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 |
|
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 #1097708 is a reply to message #1097456] |
Fri, 30 August 2013 04:14 |
sumi v 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 |
|
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 #1101082 is a reply to message #1100755] |
Wed, 04 September 2013 01:39 |
|
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 |
sumi v 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 |
|
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 #1105648 is a reply to message #1091134] |
Tue, 10 September 2013 05:43 |
|
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
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.05930 seconds