nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

charts - how to use row values in series title

birtslash

hi all 
 
i wonder if there is a way for using dataSetRow values as series title in a chart. 
 
on the 3rd tab ("format chart") in the properties panel of my chart i can modify the series titles. i can use localized labels, but i would like to use an expression like 
"from <VALUEOF>row[SOURCE]</VALUEOF> to <VALUEOF>row[TARGET]</VALUEOF>". 
 
the only solution i found so far is to do it programmatically via scripting this way: 
yAxis.getSeriesDefinitions().get(0).getSeries().get(0).setSeriesIdentifier("my new series name"); 
...but i hope there must be more convenient way to do that. 
 
if the only way to do it is by scripting,... how can i access the table/dataset data within the script? 
 
thanks for any hints in advance 
bartek

Find more posts tagged with

Comments

kclark

Hi birtslash! The only way to do what you're trying to do is by scripting. You can always put in a request for an <a class='bbc_url' href='https://bugs.eclipse.org/bugs/enter_bug.cgi?product=BIRT'>enhancement</a>

birtslash

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="112040" data-time="1354642788" data-date="04 December 2012 - 10:39 AM">
Hi birtslash! The only way to do what you're trying to do is by scripting. You can always put in a request for an <a class='bbc_url' href='https://bugs.eclipse.org/bugs/enter_bug.cgi?product=BIRT'>enhancement</a> </blockquote>
 
ok. thank you for the quick answer. 
could you please give me some hints how to do it. 
 
basically i've got a linechart and on the y-axis i use 4 series. 
i try to set the seriesidentifier in the onRender() section of the chart script. 
 
here i inserted the following code: 
 
function beforeDataSetFilled( series, idsp, icsc ) { 
 
var xAxis = chart.getAxes().get(0); 
var yAxis = xAxis.getAssociatedAxes().get(0); 
var xSerieDef = xAxis.getSeriesDefinitions().get(0); 
var ySerieDef = yAxis.getSeriesDefinitions().get(0); 
 
if (series.getSeriesIdentifier() == "actual_series_name_1") { 
series.setSeriesIdentifier("my_new_series_name_1"); 
ySerieDef.getSeries().get(0).setSeriesIdentifier("my_new_series_name_1"); 
} 
else if (series.getSeriesIdentifier() == "actual_series_name_2") { 
series.setSeriesIdentifier("my_new_series_name_2"); 
ySerieDef.getSeries().get(0).setSeriesIdentifier("my_new_series_name_2"); 
} 
} 
 
i can see (debug log) the code is executed for each of the 4 series - i get the seriesidentifiers displayed. 
i would expect now, the series get renamed as desired and that the legend items for these series get renamed as well. the result is that only the first serie is renamed which i can see in the legend, it seems the other series remain unmodified. 
what am i doing wrong?

birtslash

well, i found the solution by myself (see below). setting the series ids is enough, the legend labels are set accordingly. 
 
 
function beforeGeneration( chart, icsc ) { 
 
importPackage(Packages.java.util); 
importPackage(Packages.org.eclipse.birt.chart.model.data.impl); 
importPackage(Packages.org.eclipse.birt.chart.model.component.impl); 
importPackage(Packages.org.eclipse.birt.chart.model.type.impl); 
importPackage(Packages.org.eclipse.birt.chart.model.attribute); 
 
var xAxis = chart.getAxes().get(0); 
var yAxis = xAxis.getAssociatedAxes().get(0); 
 
// set identifiers for series 1 to 4 
yAxis.getSeriesDefinitions().get(0).getSeries().get(1).setSeriesIdentifier( "new_id_1" ); 
yAxis.getSeriesDefinitions().get(1).getSeries().get(1).setSeriesIdentifier( "new_id_2" ); 
yAxis.getSeriesDefinitions().get(2).getSeries().get(1).setSeriesIdentifier( "new_id_3" ); 
yAxis.getSeriesDefinitions().get(3).getSeries().get(1).setSeriesIdentifier( "new_id_4" ); 
} 
 
 
i think, if you want to change only the legend titles, i've found the following solution which tackles it 
 
function beforeDrawLegendItem ( lerh, bounds, icsc ) { 
 
var caption = lerh.getLabel().getCaption(); 
 
if ( caption.getValue().compareToIgnoreCase("current_legend_title_1") == 0 ) { 
caption.setValue( "new_legend_title_1" ); 
} 
else if ( caption.getValue().compareToIgnoreCase("current_legent_title_2") == 0 ) { 
caption.setValue( "new_legend_title_2" ); 
} 
} 
 
regards 
bartek