Jump to content
Changes to the Jaspersoft community edition download ×

Distinct count calculation type in crosstab

Recommended Posts

By: gintonic - gintonic_007

Distinct count calculation type in crosstab

2006-07-05 13:11



I try to use the new calculation type "Distinct Count" (available since 1.2.4 relase) in a crosstab measure.


In my table datasource with columns (CATEGORY, TRANSACTION, ... ) i have for example the following rows : (Category1, Transac1 ... ), (Category1, Transac1 ... ), (Category1, Transac2 ... ), (Category2, Transac3 ... ).


I'm using IReport to edit my crosstabs properties :

I choose CATEGORY as the bucket expression to define my row groups. I have a single column group. I define a measure with TRANSACTION as the measure expression.


If i choose "Count" as the measure calculation type, i'll have for Category1 group the result "3" in the detail cell wich display the measure ( the number of TRANSACTION occurencies : Transac1, Transac1, Transac2).


Actually, i need to display the number of distinct TRANSACTION for each group, so i choose "DistinctCount" as the calculation type. I expect "2" for the measure in Category1 ( Transac1 & Transac2 ) but i get "0".

I thus get "0" for each rows


What's wrong ?


Thanks by advance



By: Teodor Danciu - teodord

RE: Distinct count calculation type in crosst

2006-07-07 08:43




This was indeed a bug.

Could you get the latest from CVS and try see

if the problem persist. I just commited a fix.


Thank you,





By: gintonic - gintonic_007

RE: Distinct count calculation type in crosstab

2006-07-13 14:34



It's working fine now. Thank you :)

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...