How do I find out where the best students are and how to compare cities for success?

[Anonymous]

Hi, I'm a beginner and I do not get the best. I still learn how the program works and I need help.

I have two tables

1.Student with columns index number, subject Id and grade

2. and table Exam with columns index number, name. surname, address and city

 How do I find out where the best students are and how to compare cities for success?

Help me, it's urgent. thank you.

[lironbaram]

hi 

just create two bar chart 

one 

dimension FisrstName & Surname 

expression avg(grade)

this will rank the students 

second :

dimension city 

expression avg(grade)

this will grade the cities 

[Anonymous]

I didnt define first question exactly. How to make table to show where the best student live? In witch city.