Data source of Chart web part is the statistics of Customized Lists

Question

Hi,

I want to put some Chart Web Parts on my SharePoint Page to display the statistics of a customized list, but I don't know how to get the statistics.

For a simple example, I have a exam list (I name it Exam):

-----------------------------------------------

Title (single line of text)

exam 1

exam 2

.......

exam n

------------------------------------------------

and I have a record list (I name it Record):

(one teacher manages several students)

------------------------------------------------

Teacher(person or group)           Student(person or group)          Exam Name(Lookup from Exam list)  

          teacher 1                                     student 1                                          exam 1

          teacher 1                                     student 1                                          exam 2

          teacher 1                                     student 2                                          exam 1

          teacher 1                                     student 2                                          exam 3

          teacher 1                                     student 2                                          exam 4

          teacher 2                                     student 3                                          exam 1

          teacher 2                                     student 4                                          exam 2

          teacher 2                                     student 4                                          exam 5

          teacher 3                                     student 5                                          exam 3

------------------------------------------------

First, I want a Chart Web Part for a student, to display the statistics of his classmates,

for example, when student 1 open the page, he will get the list : 

(because student 1 and student 2 belong to the same teacher)

------------------------------------------------

Student                           Exam Count

student 1                              2

student 2                              3

------------------------------------------------

while when student 4 open the page, he will get the list :

------------------------------------------------

Student                           Exam Count

student 3                              1

student 4                              2

------------------------------------------------

I have read the article http://social.msdn.microsoft.com/Forums/en-us/sharepoint2010general/thread/52d828f2-e162-46f7-8db0-53a8e42d3671, but it  is not what I need.

Is there any way to do this?

Thank you.

Answer 1

create your own item style with the content query webpart with your conditions to display the data, follow below link

http://msdn.microsoft.com/en-us/library/bb850574(v=office.12).aspx

you can create temporary table to display the your data and create the connection between chart webpart and your content query webpart