Eclipse Community Forums: BIRT » Get percentage value by group

Help

Home

Home » Eclipse Projects » BIRT » Get percentage value by group

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

Get percentage value by group [message #1059533]

Mon, 20 May 2013 06:33

imtinene rjeb
Messages: 3
Registered: May 2013

Junior Member

Hi all,
I am on BIRT 2.2.1 version and can't upgrade because I am dependent on clearquest 7.1.2 version.
I have the following input
ID Submit_Date SpentDays
X1 Feb 14, 2012 7:52 AM 1
X2 Feb 14, 2012 9:49 AM 1
X3 Feb 28, 2012 9:53 PM 0

X4 Apr 13, 2012 11:27 AM 3
X5 Apr 24, 2012 11:22 AM 0
X6 Apr 25, 2012 4:29 PM 0
X7 Apr 26, 2012 2:40 PM 0

What I would like to achieve is to compute the percentage of ID which having spentdays less then 2 grouped by Submit Date and display those values on a line chart
Which means for Feb have 100% and for April 75%.

I have been able to display the total number of defects on a line chart means for
Feb 3
April 3
But all the tries to obtain percentage values by group are failing ( The best I got is having the number of defects with spent time less then 2 / Total number of defects)
Can you help please
Thanks

Report message to a moderator

Re: Get percentage value by group [message #1059870 is a reply to message #1059533]

Wed, 22 May 2013 00:15

Michael Williams
Messages: 828
Registered: July 2009

Senior Member

Have you tried doing the calculation in a table, then using that as the source of your chart? You could group a table by month, add aggregations for the total under two and for the month total and create a binding in the table that takes just the year from your date. Then, in your chart, you'd use the year binding you created for the x-axis and compute your y-axis value from the two aggregation fields.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Get percentage value by group [message #1060331 is a reply to message #1059870]

Fri, 24 May 2013 03:49

imtinene rjeb
Messages: 3
Registered: May 2013

Junior Member

Thanks michael,
I have started implementing your proposition ( actually I started using cross table but getting errors with refresh see that it is a bug on BIRT 2.2.1)
I am new on BIRT and your proposition is not all clear for me special that part :"Then, in your chart, you'd use the year binding you created for the x-axis and compute your y-axis value from the two aggregation fields."
I tried this script but getting Out Index Of Bundary errors when there are not defects in the month:
function beforeGeneration( chart, icsc )
{
importPackage(Packages.java.util);
importPackage(Packages.org.eclipse.birt.chart.model.data.impl);
importPackage(Packages.org.eclipse.birt.chart.model.type.impl);
importPackage(Packages.org.eclipse.birt.chart.model.component.impl);
var xAxis = chart.getAxes().get(0);
var yAxis = xAxis.getAssociatedAxes().get(0);
var xSerieDef = xAxis.getSeriesDefinitions().get(0);
var ySerieDefOpen = yAxis.getSeriesDefinitions().get(0);
var ySerieDefClose = yAxis.getSeriesDefinitions().get(1);

var yDataOpen = new ArrayList();
var yDataClose = new ArrayList();
var aDataOpen = new ArrayList(icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("OpenArray"));
var aDataClose = new ArrayList(icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("CloseArray"));
//aData.add(icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("OpenArray"));
//Get existing value series
var openSeries = ySerieDefOpen.getRunTimeSeries().get(0);
var closeSeries = ySerieDefClose.getRunTimeSeries().get(0);
var tmp2= openSeries.getDataSet().getValues();
var tmp3 = aDataClose.size();
var size= tmp2.length ;
for( i=1;i <= size; i++)
{
yDataOpen.add(parseFloat(aDataOpen.get(i)));
yDataClose.add(parseFloat(aDataClose.get(i)));
}

//Create data sets for series
var openValues = NumberDataSetImpl.create( yDataOpen );
var closeValues = NumberDataSetImpl.create( yDataClose );

//Set the values
openSeries.setDataSet( openValues );
closeSeries.setDataSet( closeValues );
//Clear existing series
chart.getTitle().getLabel().getCaption().setValue(tmp3);
ySerieDefOpen.getSeries().clear();
ySerieDefClose.getSeries().clear();
//Bind new series to chart

ySerieDefOpen.getSeries().add(openSeries);
ySerieDefClose.getSeries().add(closeSeries);
}
Thanks again for your help.
Regards

Report message to a moderator

Re: Get percentage value by group [message #1060708 is a reply to message #1060331]

Tue, 28 May 2013 03:15

imtinene rjeb
Messages: 3
Registered: May 2013

Junior Member

I was able to understand and resolve my issue.
Thanks for your help.
Regards

Report message to a moderator

Previous Topic:	Printing labels horizontally
Next Topic:	Unable to get PDF output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 28 22:23:36 EDT 2013