Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 0d 2h 29m 13s Coupon code: SAVE25
Free Preparation Discussions
MENU
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]
Topic #: 4
You want to show the cumulative total of each year for every state.
Which quick table calculation should you use?
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.
Jerry
1 months agoElbert
4 days agoSommer
6 days agoWilson
19 days agoElroy
25 days agoAbel
2 months agoArt
7 days agoAliza
11 days agoAnnelle
2 months agoDominga
11 days agoJennifer
13 days agoSantos
18 days agoKristian
2 months agoStephen
9 days agoLonny
10 days agoBelen
11 days agoJavier
12 days agoTy
13 days agoDomingo
14 days agoAlexia
17 days agoBlair
2 months agoLettie
1 months agoRima
1 months agoDahlia
1 months agoAmie
1 months agoChantell
2 months agoRemedios
2 months agoEmily
2 months agoLewis
3 months ago