Eclipse Community Forums: BIRT » Stacked BarChar

Home » Archived » BIRT » Stacked BarChar - change one serie to Line

Stacked BarChar - change one serie to Line [message #956292]

Wed, 24 October 2012 07:44

Eclipse User

I need to use stacked bar chart, where series are generated dynamically
by grouping. One of series (identified by name) should be displayed as
line. How to do it?

I found only switching stack/unstack or visibility in beforeDrawSeries:

var seriesID = series.getSeriesIdentifier();
if (seriesID == "total") {
series.setStacked(false); <<
}

regards
Jaroslav

Re: Stacked BarChar - change one serie to Line [message #958180 is a reply to message #956292]

Thu, 25 October 2012 16:37

Eclipse User

This post shows how you can modify a series's type, in script, but it's in the beforeFactory script, which would be before your grouping took place. I'll have to look at this a little closer to see if the series type can be changed in the chart's onRender script.

BIRT Exchange - DevShare

[Updated on: Thu, 25 October 2012 22:52] by Moderator

Re: Stacked BarChar - change one serie to Line [message #958386 is a reply to message #958180]

Thu, 25 October 2012 20:38

Eclipse User

Looks like you might be able to get this to happen, in the beforeGeneration script. With the stacked bar with optional grouping, I wasn't able to create my own lineSeries and put it in there, in some quick testing. I was able to create a hidden line series and steal one line from the hidden series definition and put it in the stacked bar visible series definition, however, it had to be a stacked series, which might not work for you.

Edit:

If you create a second identical series, in your chart only make it a line chart and unstack it. You can simply step through your series and hide the stacked bar and then step through the next series and hide all lines except the one you want to show, with a script like this:

function beforeGeneration( chart, icsc )
{
xAxis = chart.getAxes().get(0);
yAxis = xAxis.getAssociatedAxes().get(0);
sd1 = yAxis.getSeriesDefinitions().get(0);
sd2 = yAxis.getSeriesDefinitions().get(1);

for(i=0;i<sd1.getSeries().size();i++){

if(sd1.getSeries().get(i).getSeriesIdentifier() == "Series 1"){
sd1.getSeries().get(i).setVisible(true);
}
else if(sd1.getSeries().get(i).getSeriesIdentifier() == "total"){
sd1.getSeries().get(i).setVisible(false);
}
else{
sd1.getSeries().get(i).setVisible(true);
}
}
for(i=0;i<sd2.getSeries().size();i++){

if(sd2.getSeries().get(i).getSeriesIdentifier() == "Series 2"){
sd2.getSeries().get(i).setVisible(true);
}
else if(sd2.getSeries().get(i).getSeriesIdentifier() == "total"){
sd2.getSeries().get(i).setVisible(true);
}
else{
sd2.getSeries().get(i).setVisible(false);
}
}
}

[Updated on: Thu, 25 October 2012 21:28] by Moderator

Re: Stacked BarChar - change one serie to Line [message #963189 is a reply to message #958386]

Mon, 29 October 2012 12:29

Eclipse User

Use identical data for bar/stacked and line/unstacked series and change visibility was my first idea. I used similar code in beforeDrawSeries and change visibility by serie name and stack type.

	if (series.isStacked()) {
		// bar series - hide total
        if (seriesID == "total") series.setVisible(false);
	} else {
		// line - only total is visible
        if (seriesID != "total") series.setVisible(false);
	}

I have problem with same change of a legend entries. How can I reorganize entries - same way as series?

Picture show my problem if I use beforeDrawLegendItem and afterDrawLegendItem:
1) some of legend entries not in list (too much entries when doubled) = my line/total is not visible
2) after hiding entries there is unusual empty space
3) if legend entries ar organized in more columns I am lost with moving to right place

regards

Attachment: stack_line_legend.png
(Size: 94.96KB, Downloaded 414 times)

Re: Stacked BarChar - change one serie to Line [message #964539 is a reply to message #963189]

Tue, 30 October 2012 11:57

Eclipse User

I went a little bit further, in my script above and actually removed the unwanted series, rather than just hiding them. This should take care of your legend issues. Let me know your version and I can attach an example report.

Re: Stacked BarChar - change one serie to Line [message #965398 is a reply to message #964539]

Wed, 31 October 2012 03:48

Eclipse User

I use BIRT 4.2.1, chart version is 2.5.3

Re: Stacked BarChar - change one serie to Line [message #968722 is a reply to message #956292]

Fri, 02 November 2012 13:53

Eclipse User

Sorry for the delay. I upgraded computers and had to get everything transferred over. Take a look at this example.