BlackFriday 2024! 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 2 Question 49 Discussion

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

You have the following chart that sorts states by the number of products each state has purchased.

Which formula should you use to include a number with the position of each state within each region?

Show Suggested Answer Hide Answer
Suggested Answer: D

The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to include a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position.Reference:The information is inferred from general Tableau knowledge as well as the following sources:

Tableau Functions (Alphabetical)

LOOKUP

Tableau Certified Data Analyst Exam Guide


Contribute your Thoughts:

Francesco
2 months ago
I think Talia is right, WINDOW_SUM(SUM ([Quantity])) makes more sense for including a number with the position of each state within each region.
upvoted 0 times
...
Wynell
2 months ago
But wouldn't INDEX() be more appropriate for finding the position of each state within each region?
upvoted 0 times
...
Matthew
2 months ago
B) INDEX () is the way to go, no doubt about it. Unless you want to end up in the doghouse, that is.
upvoted 0 times
...
Johnathon
2 months ago
D) LOOKUP (SUM ([Quantity])) is a bit of a wild card. I don't think it's the right fit for this problem. B) is the clear winner in my opinion.
upvoted 0 times
Malcolm
16 days ago
I'm not sure about D) LOOKUP (SUM ([Quantity])), but I would go with B) INDEX () as well.
upvoted 0 times
...
Boris
17 days ago
C) WINDOW_SUM(SUM ([Quantity])) could also work, but I still think B) INDEX () is the better option.
upvoted 0 times
...
Tarra
18 days ago
I agree, B) INDEX () seems like the most appropriate formula to use.
upvoted 0 times
...
Fausto
1 months ago
I think B) INDEX () is the best choice here.
upvoted 0 times
...
...
Talia
2 months ago
I disagree, I believe the correct answer is C) WINDOW_SUM(SUM ([Quantity]))
upvoted 0 times
...
Lino
2 months ago
A) FIRST () sounds like it would just give you the first state in the region, which isn't what we need. B) INDEX () is the way to go.
upvoted 0 times
Bulah
2 months ago
Yeah, FIRST () would only give us the first state, but INDEX () is what we need.
upvoted 0 times
...
Glenn
2 months ago
I agree, INDEX () would give us the position of each state within each region.
upvoted 0 times
...
...
Wynell
2 months ago
I think the answer is B) INDEX()
upvoted 0 times
...
Nickolas
3 months ago
C) WINDOW_SUM(SUM ([Quantity])) is an interesting option, but I don't think it's the correct formula for this task. The question is asking for the position, not the sum.
upvoted 0 times
Marion
2 months ago
I agree, B) INDEX () would be the right choice for this task.
upvoted 0 times
...
Marion
2 months ago
I think the correct formula is B) INDEX ()
upvoted 0 times
...
...
Art
3 months ago
B) INDEX () seems like the right choice here. It allows you to grab the position of each state within the region.
upvoted 0 times
Lyla
2 months ago
I think C) WINDOW_SUM(SUM ([Quantity])) would not give us the position of each state within the region.
upvoted 0 times
...
Toi
2 months ago
Yes, B) INDEX () will give us the position of each state within the region.
upvoted 0 times
...
Freeman
2 months ago
I agree, B) INDEX () is the correct formula to use in this case.
upvoted 0 times
...
...

Save Cancel