Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
iccent2
5 months, 4 weeks 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
5 months, 4 weeks ago
Selected Answer: D
By calculating the shown resulat D. (SUM([Sales]) - LOOKUP(SUM([Sales]), -4)) / (LOOKUP(SUM([Sales]), -4))
upvoted 1 times
...
88c0ad8
6 months, 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
6 months, 3 weeks ago
Option A
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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