raja.shekar Posted November 18, 2014 Share Posted November 18, 2014 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 Link to comment Share on other sites More sharing options...
Solution rajesh.sirsikar Posted November 19, 2014 Solution Share Posted November 19, 2014 Hi,Please refer my blog http://www.rajeshsirsikar.com/selecting-top-n-values-from-a-csv-datasource-jaspersoft-studio/Thanks,Rajesh S Link to comment Share on other sites More sharing options...
raja.shekar Posted November 20, 2014 Author Share Posted November 20, 2014 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. Link to comment Share on other sites More sharing options...
raja.shekar Posted November 21, 2014 Author Share Posted November 21, 2014 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. Link to comment Share on other sites More sharing options...
rajesh.sirsikar Posted November 26, 2014 Share Posted November 26, 2014 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 Link to comment Share on other sites More sharing options...
raja.shekar Posted November 26, 2014 Author Share Posted November 26, 2014 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.... Link to comment Share on other sites More sharing options...
rajesh.sirsikar Posted November 28, 2014 Share Posted November 28, 2014 Hi Shekar, Are there any fixed number of CallTypes or they have variable numbers?? Rajesh Link to comment Share on other sites More sharing options...
raja.shekar Posted November 28, 2014 Author Share Posted November 28, 2014 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.. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now