ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 73 - TDA-C01 discussion

Report
Export

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?

A.
FIRST ()
Answers
A.
FIRST ()
B.
INDEX ()
Answers
B.
INDEX ()
C.
WINDOW_SUM(SUM ([Quantity]))
Answers
C.
WINDOW_SUM(SUM ([Quantity]))
D.
LOOKUP (SUM ([Quantity]))
Answers
D.
LOOKUP (SUM ([Quantity]))
Suggested answer: D

Explanation:

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

asked 23/09/2024
Daniel Hernandez Villar
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first