Need to find Top10 results pie chart in Ireports using Domain dataset.

[raja.shekar]

I need to find the top 10 results records in pie chart by countwise in iReport using domain dataset. Please Can anyone help me on this.. Immediate response would be more helpful

[rajesh.sirsikar]

Hi,

Please refer my blog 

http://www.rajeshsirsikar.com/selecting-top-n-values-from-a-csv-datasource-jaspersoft-studio/

Thanks,

Rajesh S

[raja.shekar]

Hi rajesh,

Thanks for your reply.

i need to find the top10 values using the count.

For example  i have a field called "CallType" and i have created a variable called "CallCount"  which is count of "CallType" field. So i need to use CallType field in Category section of Piechart and CallCount  variable as measure. In the above case i need  to show in a piechart which consist of only top 10 biggest "CallCount"   CallTypes.

Thank you once again.

Waiting for your valuable comment.

[raja.shekar]

Hi rajesh,

 

Thanks for your reply.

 

i need to find the top10 values using the count.

 

For example i have a field called "CallType" and i have created a variable called "CallCount" which is count of "CallType" field. So i need to use CallType field in Category section of Piechart and CallCount variable as measure. In the above case i need to show in a piechart which consist of only top 10 biggest "CallCount" CallTypes.

 

Thank you once again.

 

Waiting for your valuable comment.

[rajesh.sirsikar]

Hi Shekar,

 

I did not understand the exact requirement. Do you want Data as below.

 

CallType CallCount

TypeA 5

TypeA 5

TypeA 5

TypeA 5

TypeA 5

TypeB 3

TypeB 3

TypeB 3

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeC 11

TypeD 2

TypeD 2

 

 

 

[raja.shekar]

Hi Rajesh,

 

I need the results as like follows:

 

CallType CallCount

TypeA 250 (Number of records in the domain dataset for the CallTypeA)

TypeB 540 (Number of records in the domain dataset for the CallTypeB)

TypeC 100034 (Number of records in the domain dataset for the CallTypeC)

 

Like above i need to show the result in pie chart....

[rajesh.sirsikar]

Hi Shekar,

 

Are there any fixed number of CallTypes or they have variable numbers??

 

Rajesh

[raja.shekar]

Hi Rajesh,

 

No there is no fixed number of callTypes. i just given the sample number of records for some calltypes. they just variable number...and also i need to show the output in pie chart..