Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Aggregating "column based"
Aggregating "column based" [message #811354] Fri, 02 March 2012 08:28 Go to next message
Tom Mising name is currently offline Tom Mising nameFriend
Messages: 29
Registered: July 2009
Junior Member
Hello,

I have a problem while creating a report.

I am using BIRT 2.3 with a mysql database.

My table looks like

"grouping","x","y"
1,-0.004253063,-0.002339738
2,0.006725857,0.002955924
3,-0.003102467,0.007429517
1,-0.006085681,-0.006151364
2,0.01217442,0.001887013
3,-0.006356443,0.01047763
1,-0.0114442,0.01186888
2,0.01169455,0.002339335
3,0.002002897,0.02559207
1,-0.008326302,0.009104015
2,0.006026436,0.00144702
3,0.003647684,0.01689492

Now I need to build the difference from the x values where grouping is 3 and 2 and build the average, standard deviation, minimun and maximum from that.

It means I have -0.003102467, -0.006356443 and so on for x where grouping is 3 and 0.006725857, 0.01217442 and so on where grouping is 2.
Then I have to aggregate the result to avg, std, min and max.

The problem is, that the values looks like "row based", but what I need is a "column based" result.

How could I realize this in help with the BIRT engine?


Thanks,
Tom
Re: Aggregating "column based" [message #811873 is a reply to message #811354] Fri, 02 March 2012 23:24 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

What do you want the report output to look like?

Jason

On 3/2/2012 3:28 AM, Tom Mising name wrote:
> Hello,
>
> I have a problem while creating a report.
>
> I am using BIRT 2.3 with a mysql database.
>
> My table looks like
>
> "grouping","x","y"
> 1,-0.004253063,-0.002339738
> 2,0.006725857,0.002955924
> 3,-0.003102467,0.007429517
> 1,-0.006085681,-0.006151364
> 2,0.01217442,0.001887013
> 3,-0.006356443,0.01047763
> 1,-0.0114442,0.01186888
> 2,0.01169455,0.002339335
> 3,0.002002897,0.02559207
> 1,-0.008326302,0.009104015
> 2,0.006026436,0.00144702
> 3,0.003647684,0.01689492
>
> Now I need to build the difference from the x values where grouping is 3
> and 2 and build the average, standard deviation, minimun and maximum
> from that.
>
> It means I have -0.003102467, -0.006356443 and so on for x where
> grouping is 3 and 0.006725857, 0.01217442 and so on where grouping is 2.
> Then I have to aggregate the result to avg, std, min and max.
>
> The problem is, that the values looks like "row based", but what I need
> is a "column based" result.
>
> How could I realize this in help with the BIRT engine?
>
>
> Thanks,
> Tom
Previous Topic:How to remove column in chart
Next Topic:Localization of DataSet Field
Goto Forum:
  


Current Time: Sun Nov 28 00:40:25 GMT 2021

Powered by FUDForum. Page generated in 0.02005 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top