Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Aggregating Percentage
Aggregating Percentage [message #547815] Mon, 19 July 2010 16:03 Go to next message
Eclipse UserFriend
Originally posted by: remkus.wideopenwest.com

I have a report with a column that contains SLA targets for applications
as a percentage.

The report will be aggregating the list of applications into groups.

My requirement is to express the SLA target for the group of
applications as the array of application SLA targets multiplied
together, basically assuming independent probability .... i.e. SLA1 *
SLA2 .... * SLAn.

I'm using BIRT 2.2.2 (yeah, I'm tethered to this version). If BIRT
handles this easily with it's aggregates, I guess I'm just overlooking
it, so I'll apologize in advance.

Do I need to write a custom aggregate to do this? Is there a good
example out there someone can point me to?

Would it be easier to do in my query? (I'm using DB2 as a backend)

Thanks
Re: Aggregating Percentage [message #548727 is a reply to message #547815] Thu, 22 July 2010 18:13 Go to previous message
Scott Rosenbaum is currently offline Scott RosenbaumFriend
Messages: 425
Registered: July 2009
Senior Member
Dave,

Not sure I follow what you are trying to do, it sounds like you might be
able to do it through expressions, but my guess is a custom aggregation will
be much easier to use and test.

Scott

> I have a report with a column that contains SLA targets for
> applications as a percentage.
>
> The report will be aggregating the list of applications into groups.
>
> My requirement is to express the SLA target for the group of
> applications as the array of application SLA targets multiplied
> together, basically assuming independent probability .... i.e. SLA1 *
> SLA2 .... * SLAn.
>
> I'm using BIRT 2.2.2 (yeah, I'm tethered to this version). If BIRT
> handles this easily with it's aggregates, I guess I'm just overlooking
> it, so I'll apologize in advance.
>
> Do I need to write a custom aggregate to do this? Is there a good
> example out there someone can point me to?
>
> Would it be easier to do in my query? (I'm using DB2 as a backend)
>
> Thanks
>
Previous Topic:Actuate 8 Report Errors
Next Topic:Dynamic Sql query in birt
Goto Forum:
  


Current Time: Sat Nov 29 05:22:13 GMT 2014

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

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