Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Analytics-DA-201 Exam - Topic 1 Question 16 Discussion

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?
B) (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
A) (SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
C) (SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
D) (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

Salesforce Analytics-DA-201 Exam - Topic 1 Question 16 Discussion

Actual exam question for Salesforce's Analytics-DA-201 exam
Question #: 16
Topic #: 1
[All Analytics-DA-201 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?

Show Suggested Answer Hide Answer
Suggested Answer: B

The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.Reference:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide


Contribute your Thoughts:

0/2000 characters
Krystina
2 days ago
I’m leaning towards option A, but I’m not entirely confident. I need to double-check how the LOOKUP function works in this context.
upvoted 0 times
...
Linn
7 days ago
I feel like I might confuse the LOOKUP function with something else. Wasn't there a similar question about year-over-year comparisons?
upvoted 0 times
...
Luisa
12 days ago
I think option B looks familiar; it seems to be the standard formula for calculating percent change.
upvoted 0 times
...
Kimbery
17 days ago
I remember practicing percent difference calculations, but I'm not sure if it's just the subtraction or if we need to divide by the previous year's sales.
upvoted 0 times
...

Save Cancel