Home » Archived » BIRT » Aggregating "column based"
Aggregating "column based" [message #811354] |
Fri, 02 March 2012 08:28 |
Tom Mising name 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 |
|
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
|
|
|
Goto Forum:
Current Time: Thu Apr 25 14:05:04 GMT 2024
Powered by FUDForum. Page generated in 0.03298 seconds
|