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

Clear chart series and pass new data

shivkumar150

Hi All,
 
I've somewhat achieved my goal but till midway. Using CSV datasource, I increment report variables to get count of a specific data. Now using these variables, I need to plot a bar chart. In the afterDatasetFilled function, I need to clear the existing series and put the report variable data.
 
Dataset afterClose method
<pre class="_prettyXprint">
reportContext.setGlobalVariable("Tcad",vars["totalcad"]); </pre>
Chart afterDatasetFilled method
<div>
<pre class="_prettyXprint">
function afterDataSetFilled( series, dataSet, icsc )
{
importPackage( Packages.java.util );
importPackage(Packages.java.lang);
importPackage( Packages.org.eclipse.birt.chart.model.type.impl );
importPackage( Packages.org.eclipse.birt.chart.model.data.impl);

rpCtx=icsc.getExternalContext().getScriptable();
var totalCad=rpCtx.getGlobalVariable("Tcad");

var newseriesarr=new ArrayList();
if(series.getSeriesIdentifier()=="Series1"){
newseriesarr.add(totalCad);
}else{
newseriesarr.add("TotalCAD");
}

if(series.getSeriesIdentifier()=="Series1"){
dataSet.setValues(newseriesarr);
}else{
dataSet.setValues(newseriesarr);
}</pre>
</div>
It is the series clearing and adding the new dataSet, that is pending.
 
Or is there any more effective way to achieve the bar chart creation with data aggregation.
 
I've attached the rptdeisgn and csv datasource.

Find more posts tagged with

Comments

Clement Wong

What is the "count of a specific data"?
 
It appears from your code in onFetch that you want to count for each "Item", if the "ItemType" contains 'CAD' and Status is 'Released'?
 
There is an easier way. Instead of the code that you implemented, in the Chart, you can change the Value (Y) Series aggregation function from Default (Sum) to Count.
 
And in the Expression for that:
<pre class="_prettyXprint">
if (row["ItemType"].toLowerCase().indexOf("cad")!=-1) {
if (row["Status"] == 'Released') 1;
else null;
}
else {
null;
}
</pre>
Also, all the code in beforeOpen, onFetch, afterClose, etc... can be removed and be replaced by inserting Aggregation(s) instead.
 
For example, COUNT of all CAD:
<pre class="_prettyXprint">
if (row["ItemType"].toLowerCase().indexOf("cad")!=-1) {
1;
}
else {
null;
}
</pre>
Attached is a revised design modified and tested in OS BIRT 4.5.0.

shivkumar150

Thanks Clement for the quick reply.
 
So, finally achieved the needed report. Your advice of changing Value (Y) series aggregation helped. 
So, the major changes were as follows:
1) Changed Value(Y) Series aggregation to Count.
2) In Category (X) Series, I selected the ItemType, which sorted the data according to data type.
3) Created another series, where data was sorted according to "Status" using below script:
<div>
<pre class="_prettyXprint">
if (row["Status"] == 'Released') 1;
else null;</pre>
</div>
Thanks once again for quick help.
 
BIRT version 4.5.0