ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 99 - TDA-C01 discussion

Report
Export

You want to create the following table in a view.

Which function should you use to create the Position column?

A.
RANK
Answers
A.
RANK
B.
FIRST
Answers
B.
FIRST
C.
INDKX
Answers
C.
INDKX
D.
LAST
Answers
D.
LAST
Suggested answer: B

Explanation:

To create the Position column, you should use the FIRST () function. The FIRST () function returns the number of rows from the current row to the first row in the partition. For example, the first row in a partition will return 0, the second row will return -1, and so on. In this question, the partition is defined by the Segment field, and the table is sorted by the Sales field in descending order. Therefore, the Position column shows the offset of each row from the first row in each segment, based on the sales ranking.Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 11, section ''Creating Calculated Fields''

Tableau Help: FIRST Function

asked 23/09/2024
asd asd
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first