Eclipse Community Forums: BIRT » Stacked BarChar

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Wed, 24 October 2012 11:44

Jaroslav Uher

Messages: 17
Registered: July 2009

Junior Member

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

Report message to a moderator

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

Thu, 25 October 2012 20:37

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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

Michael

Developer Evangelist, Silanis

[Updated on: Fri, 26 October 2012 02:52]

Report message to a moderator

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

Fri, 26 October 2012 00:38

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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);
}
}
}

Michael

Developer Evangelist, Silanis

[Updated on: Fri, 26 October 2012 01:28]

Report message to a moderator

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

Mon, 29 October 2012 16:29

Jaroslav Uher

Messages: 17
Registered: July 2009

Junior Member

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 345 times)

Report message to a moderator

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

Tue, 30 October 2012 15:57

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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.

Michael

Developer Evangelist, Silanis

Report message to a moderator