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

- 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?

AFIRST ()

BINDEX ()

CWINDOW_SUM(SUM ([Quantity]))

DLOOKUP (SUM ([Quantity]))

Show Suggested 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

by Latosha at Aug 24, 2024, 03:55 AM

Limited Time Offer

25%

Off

Get Premium TDA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Francesco

6 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

6 months ago

But wouldn't INDEX() be more appropriate for finding the position of each state within each region?

upvoted 0 times

...

Matthew

6 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

6 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

5 months ago

I'm not sure about D) LOOKUP (SUM ([Quantity])), but I would go with B) INDEX () as well.

upvoted 0 times

...

Boris

5 months ago

C) WINDOW_SUM(SUM ([Quantity])) could also work, but I still think B) INDEX () is the better option.

upvoted 0 times

...

Tarra

5 months ago

I agree, B) INDEX () seems like the most appropriate formula to use.

upvoted 0 times

...

Fausto

6 months ago

I think B) INDEX () is the best choice here.

upvoted 0 times

...

...

Talia

6 months ago

I disagree, I believe the correct answer is C) WINDOW_SUM(SUM ([Quantity]))

upvoted 0 times

...

Lino

7 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

6 months ago

Yeah, FIRST () would only give us the first state, but INDEX () is what we need.

upvoted 0 times

...

Glenn

6 months ago

I agree, INDEX () would give us the position of each state within each region.

upvoted 0 times

...

...

Wynell

7 months ago

I think the answer is B) INDEX()

upvoted 0 times

...

Nickolas

7 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

6 months ago

I agree, B) INDEX () would be the right choice for this task.

upvoted 0 times

...

Marion

6 months ago

I think the correct formula is B) INDEX ()

upvoted 0 times

...

...

Art

7 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

6 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

6 months ago

Yes, B) INDEX () will give us the position of each state within the region.

upvoted 0 times

...

Freeman

7 months ago

I agree, B) INDEX () is the correct formula to use in this case.

upvoted 0 times

...

...