TDA-C01 Exam - Question 30

Question

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?

Examice · Accepted Answer

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.

CollectiveConsciousness · Answer

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.

MonBouj · Answer

80, 
75.5, 
71

Pdel · Answer

https://help.tableau.com/current/prep/en-us/prep_calculations.htm

TDA-C01 Exam - Question 30

Discussion