| More help with Aggregates in 2.2? [message #254092] |
Fri, 31 August 2007 10:41  |
Eclipse User |
|
|
|
So it appears that the way aggregate functions work in 2.2 has
drastically changed from the time "Integrating and Extending BIRT" and
most help files were written. Is there any documentation as to the changes?
It seems like you can't access the aggregate functions by typing them in
anymore. It doesn't even look like you can just add aggregation in the
edit bindings. It seems like you can only use the aggregation tool in
the palate, but I can't find any documentation to confirm.
Essentially what I want to do is take a groups Total.last returns, and
average them. It looks like I used to be able to do this like this
Total.ave((Total.last(row["MyRow"], MySubGroup)), MyMainGroup). Do I
have to use the Aggration tool? Or can I hand write, or use the
expression builder in some way to access these functions?
Steven
|
|
|
| Re: More help with Aggregates in 2.2? [message #254149 is a reply to message #254092] |
Sun, 02 September 2007 22:14  |
| Eclipse User |
|
|
|
Hi
You can define your aggregation both by using the new aggregation builder
in palette and writing the script such as Total.sum by yourself. They both
works as the same result. Your script: Total.ave((Total.last(row["MyRow"],
MySubGroup)), MyMainGroup) has some mistaken input. You should quotes your
groups' name
Total.ave((Total.last(row["MyRow"], "MySubGroup")), "MyMainGroup").
Regards!
|
|
|
Powered by
FUDForum. Page generated in 0.04631 seconds
Home