Chart using .csv data

I have created a simple .csv file with student details (admin_nbr, first_name, last_name, course_of_study) and filled in a few student's details into the .csv file.

I want to create a pie chart or a bar graph showing there's how many students in each course...

For example my student.csv file contains the following information:
admin_nbr, first_name, last_name, course_of_study;
062878E, Catherine, Tok, Information Technology;
078955D, Desiree, Lam, Information Technology;
068594E, Stella, Koay, Business Informatics;
080504E, Angeline, Lim, Marketing;
075959C, Benedict, Chan, Business Informatics;

I want a pie chart:
To show that there's 2 information technology student, 2 business informatics student and 1 marketing student..

Or a bar graph similar as above. How can I do that? Which should I put in x-axis, y-axis and must I aggregate or anything? Please advise me my proj is going to due in less than 24hrs time.

Thanks.

Catherine

Find more posts tagged with

Comments

bhanley

You cannot handle the aggregations inside the chart engine. You have to set up your data source with the aggregations you want to chart already on-board. So for the pie chart you want to build, you would need a data source with the following: 
 
<blockquote class='ipsBlockquote' >
course_of_study,count 
Information Technology,2 
Business Informatics,2 
Marketing,1 </blockquote>
 
With that CSV, you would add a Pie Chart, set the "course_of_study" field as the category (X-Axis on a bar chart) and "count" as the slice size definition (Y-Axis on a bar chart). 
 
This is only really challenging because you are using a CSV file. These kids of operations are really easy to have a database do for you before the data are sent to the reporting engine.

catherine

hi thanks.

I have already created a new data source with flat file connection (cannot remember the exact connection cuz I dont have the prog in my laptop) and created the dataset.

I've drag the data to a table and i'm able to view the data when preview it. So how do I do the aggregation about courseCOUNT?

Thanks plenty

davdoo

It's a really good question.
I would like to do the same.
But the answer of bhanley seems me no efficient. Because BIRT is able to compute (with aggregation), so why don't it able to count columns?
That's the question and it's very mysterious

Virgil Dodson

H Catherine,

It is probably too late for you, but it certainly is possible for a BIRT chart to do some counting. You do this by enabling grouping on the X-axis field (Course), and then selecting COUNT as the aggregrate expression on the x-axis grouping. Then you can put whatever you want for Y-axis since it is just counting. I created an example with BIRT 2.3.2 and it is enclosed.