ExamTopics Logo
Mail Us[email protected]
Menu
Tableau Discussions
exam questions

Exam TDA-C01 All Questions

View all questions & answers for the TDA-C01 exam
Go to Exam

Exam TDA-C01 topic 1 question 83 discussion

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

You have the following dataset.



Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

  • A. (SUM([Sales]) / (LOOKUP(SUM([Sales]), -4))
  • B. (SUM([Sales]) - LOOKUP(SUM([Sales]), -4))
  • C. (ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -4))
  • D. (SUM([Sales]) - LOOKUP(SUM([Sales]), -4)) / (LOOKUP(SUM([Sales]), -4))
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by ca26d8e at May 8, 2024, 4 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
iccent2
3 weeks, 5 days ago
D is the correct answer. If anyone is still in doubt, calculate for 2011Q1 using option D: (2011Q1 - 2010Q1)/2010Q1 and check the answer in the calculation column on the table.
upvoted 1 times
...
MonBouj
3 weeks, 6 days ago
Selected Answer: D
By calculating the shown resulat D. (SUM([Sales]) - LOOKUP(SUM([Sales]), -4)) / (LOOKUP(SUM([Sales]), -4))
upvoted 1 times
...
88c0ad8
1 month, 2 weeks ago
No, option A is wrong. You need to calculate the change in dynamic in order to see increase or decrease of sales compared to previous quarter. Therefore there is only formula D can work in this case
upvoted 2 times
...
ca26d8e
1 month, 2 weeks ago
Option A
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago