Dear all,
I created a Dashboard and displayed a report up in the screen. Right below the "List" report I'd like to add a field that displays the AVG value of a "VOTE" field that I'm displaying up in the screen.
This field must be dynamic because it should reflect the average vote of the above selected report.
Say for example the report is displaying all the votes a student got for multiple topics, it has multiple lines per student with different votes depending on the subject. The field should calculate the average of the vote of the list: by default, if I run the list for all the students, it should get the average vote of all the students. Then , if I navigate the list and filter by a specific student, my field should be updated and display the average vote of the selected records.
Any idea on how I can get such a field?
many thanks
A.