You have the following visualization.
You create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
Exam TDA-C01 All QuestionsBrowse all questions from this exam
Question 30
Correct Answer: B
In the given visualization, to determine the Rank Score value for Student ID 4220, you first need to check the average scores in order to rank them. The average scores in descending order are: 80, 75.5, 71, 71, 67, 66, and 64. Using the RANK function in Tableau, which does not differentiate between equal values and assigns the same rank to identical scores, we can count the scores. The scores are ranked as follows: 80 is rank 1, 75.5 is rank 2, and both 71 scores will share the rank 3. Therefore, the Rank Score value for Student ID 4220 is 4.
Discussion
CollectiveConsciousnessOption: D
The answer should be D. As we are using rank function, which does not differentiate between same values. Before student 4220 we have 2 values that are above, and then 2 values that match theirs. Therefore two students would be sharing rank 3.
MonBoujOption: D
80, 75.5, 71
PdelOption: D
https://help.tableau.com/current/prep/en-us/prep_calculations.htm