Tableau Exam Desktop-Specialist Topic 8 Question 50 Discussion

Actual exam question for Tableau's Desktop-Specialist exam

Question #: 50
Topic #: 8

Which of the following is the correct way to calculate Profit Ratio in Tableau?

AProfit / Sales

BSales / Profit

CSUM(Profit) / SUM(Sales)

DSUM(Sales)/SUM(Profit)
THIS IS A VERY IMPORTANT QUESTION
Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.
If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.
In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!
BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!
An example:

Show Suggested Answer

Suggested Answer: C

https://www.linkedin.com/pulse/tableau-tip-dont-make-error-ratio-calculations-bob-newstadt

by Deandrea at May 03, 2022, 10:07 AM

Limited Time Offer

25%

Off

Get Premium Desktop-Specialist Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!