Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam TDA-C01 All Questions

View all questions & answers for the TDA-C01 exam

Exam TDA-C01 topic 1 question 24 discussion

Actual exam question from Tableau's TDA-C01
Question #: 24
Topic #: 1
[All TDA-C01 Questions]

HOTSPOT -
You have the following visualization.

You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Show Suggested Answer Hide Answer
Suggested Answer: IF [Ship Date] = FIRST() THEN COUNT([Returns]) END

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
iccent2
6 months, 2 weeks ago
The answer is FIRST(). I tried it using sales. IF FIRST()= 0 THEN SUM([Sales]) END
upvoted 2 times
...
gsing11
1 year, 3 months ago
First() = 0 gives you a boolean(true) which shows you the first year of count of orders
upvoted 1 times
...
CollectiveConsciousness
1 year, 3 months ago
The answer is incorrect. You can't compare date and integer values. The correct answers can be First() = 0, or Index() = 1. Both would work on a filters page to return the first year.
upvoted 4 times
...
Dilara
1 year, 4 months ago
First()=0
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...