Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Tableau Exam TDA-C01 Topic 4 Question 30 Discussion

Actual exam question for Tableau's TDA-C01 exam
Question #: 30
Topic #: 4
[All TDA-C01 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.

Here is how the table would look like after applying the rank function and sorting:

As you can see, the rank score value for Student ID 4220 is1.


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel