How to get data from csv file to design pie chart

ManikantaC

Hi friends,
Iam very new to the Birt here my requirement is i want to design one pie chart getting data from csv file my problem is there almost 10,000 records is there and duplicates also there in the csv file so i want to calculate the duplicates count and in that count i want to show the top 14 records and remaining count will be others in the pie chart that to i want to use only birt functions but not js but i dont know how to create birt functions and where i want to creat please help me friends.

The format of my csv file is like this

SERIES_DESC COUNT

Maths 238
COR 190
SAS 143
Maths2
CoR 67
Maths 65
SAS 64
COR 1 60
Sag 58
Sag 52

please help me frnds,

Thanks and Regards,
E.Manikanta

Virgil Dodson

Hi E.Manikanta,

Pie Charts can get thier data directly from a Data Set... or they can get data from another BIRT control... like a table. For your example, you can create a table that groups on SERIES_DESC, and the SUMs COUNT. Name your table... and then create a pie chart that gets its data from the table. Select the grouped field for the category, and your new grouped COUNT field for the Values. As for showing only the top 14, there is a feature on the Category Series of the chart, that lets you specifiy a minimum slice size or percentage. I created an example (enclosed) that shows the top 4 based on your data.