Eclipse Community Forums: BIRT » Aggregating Percentage

Help

Home

Home » Archived » BIRT » Aggregating Percentage

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

Aggregating Percentage [message #547815]

Mon, 19 July 2010 16:03

Eclipse User

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

Report message to a moderator

Re: Aggregating Percentage [message #548727 is a reply to message #547815]

Thu, 22 July 2010 18:13

Scott Rosenbaum

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
>

Report message to a moderator

Previous Topic:	Actuate 8 Report Errors
Next Topic:	Dynamic Sql query in birt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:26:02 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter