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

11 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

11 months ago

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

upvoted 0 times

...

Matthew

11 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

11 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

9 months ago

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

upvoted 0 times

...

Boris

9 months ago

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

upvoted 0 times

...

Tarra

9 months ago

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

upvoted 0 times

...

Fausto

10 months ago

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

upvoted 0 times

...

...

Talia

11 months ago

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

upvoted 0 times

...

Lino

11 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

11 months ago

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

upvoted 0 times

...

Glenn

11 months ago

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

upvoted 0 times

...

...

Wynell

11 months ago

I think the answer is B) INDEX()

upvoted 0 times

...

Nickolas

11 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

11 months ago

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

upvoted 0 times

...

Marion

11 months ago

I think the correct formula is B) INDEX ()

upvoted 0 times

...

...

Art

12 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

11 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

11 months ago

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

upvoted 0 times

...

Freeman

11 months ago

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

upvoted 0 times

...

...