11 Replies Latest reply on Sep 4, 2018 10:58 PM by k ll

    Get Top N results year on year and show the changes by filtering year

    k ll

      Hi guys ,


      need someone to shed some light on the chart


      1.  i want to see the top students and their results by selecting a year filter

      2. in the same time , i want to see how each student's score compares against the average score of that year .

      3. when the year filter changes , the students , results and average results will change automatically.


      Another scenario is :


      i want to see how student 2 performs year on year so i have two scenarios as below that need to show the difference based on the results


      Can anyone help with this?

      Many thanks

      (ideal viz)