To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.
Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):
Student ID 4183: 39 (Rank 1)
Student ID 4220: 71 (Rank 6)
Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank) Student ID 4124: 75.5 Student ID 4050: 64 Student ID 4205: 67 Student ID 4056: 66 Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.
Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.
https://help.tableau.com/current/prep/en-us/prep_calculations.htm