Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Unique Count(I am trying to get an accurate count on a report with repeats)

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

Unique Count [message #690034]

Tue, 28 June 2011 20:20

Bob

Messages: 7
Registered: June 2011

Junior Member

Hello,
I am trying to use the computed columns count feature to count the rows in my first column. The column is a simple list of three digit integers (123, 244, 589, ect...), but there are integer repeats in the column. I am looking to create a count for unique integers in the column. How would I do this?

Report message to a moderator

Re: Unique Count [message #690056 is a reply to message #690034]

Tue, 28 June 2011 21:37

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Add a compute column that does a distinct count on the integer. See
attached example.

Jason

On 6/28/2011 4:20 PM, Bob wrote:
> Hello,
> I am trying to use the computed columns count feature to count the rows
> in my first column. The column is a simple list of three digit integers
> (123, 244, 589, ect...), but there are integer repeats in the column. I
> am looking to create a count for unique integers in the column. How
> would I do this?

Attachment: aggregation.rptdesign
(Size: 7.05KB, Downloaded 395 times)

Report message to a moderator

Previous Topic:	Generate parameter value from report dataset
Next Topic:	path for image reference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:19:36 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter