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

Tableau Exam Desktop-Certified-Associate Topic 7 Question 21 Discussion

Actual exam question for Tableau's Desktop-Certified-Associate exam
Question #: 21
Topic #: 7
[All Desktop-Certified-Associate Questions]

Why might this LOD expression for percent of total sales give different results than a table calculation for percent of total sales?

Larger image

Show Suggested Answer Hide Answer
Suggested Answer: B

Drop the year to the Columns and change it Discrete. Drop the matches played to the Rows.

Go to the Analytics menu, drop the Distribution band to the view. Select scope as entire table.

Value Computation should be:

Your view will look like this:


Contribute your Thoughts:

Tijuana
28 days ago
Wait, so we're talking about percent of total sales, not percent of total laughs. That's the real issue here, folks!
upvoted 0 times
...
Antonio
29 days ago
I bet the table calculation is the issue. If it's not configured correctly, the percent of total sales will be off. Option C is my pick.
upvoted 0 times
Brigette
6 days ago
I agree, option C seems like the most likely reason for the difference in results between the LOD expression and the table calculation.
upvoted 0 times
...
Jarod
10 days ago
I think you're right. If the table calculation is not set up correctly, it can definitely affect the results.
upvoted 0 times
...
...
Romana
1 months ago
Hmm, maybe the market filter is the culprit. Gotta make sure that's set up properly. Option A could be the answer.
upvoted 0 times
Delmy
17 days ago
User 2: Yeah, that could be the reason for the different results.
upvoted 0 times
...
Chauncey
26 days ago
User 1: I think the market filter might not be set up correctly.
upvoted 0 times
...
...
Quentin
1 months ago
If the LOD expression is not set up correctly, it could definitely lead to different results. I'd say option B is the way to go.
upvoted 0 times
Val
23 days ago
I think the filter being applied before the Table calculation is performed could also be a reason for the different results.
upvoted 0 times
...
Paola
26 days ago
Maybe the market filter is not correctly set up, causing the difference in results.
upvoted 0 times
...
Alease
1 months ago
I agree, if the LOD expression is not set up correctly, it could definitely lead to different results. Option B seems like the most likely reason.
upvoted 0 times
...
...
Wai
2 months ago
The LOD expression and table calculation might give different results because the filter is applied before the table calculation is performed. Option D sounds like the correct answer here.
upvoted 0 times
Sage
15 days ago
But what if the LOD expression or table calculation is not set up correctly?
upvoted 0 times
...
Helaine
16 days ago
Yeah, that makes sense. So option D is probably the correct answer.
upvoted 0 times
...
Jannette
26 days ago
Yes, option D mentions that the filter is applied before the table calculation is performed.
upvoted 0 times
...
Verona
1 months ago
I think the filter is applied before the table calculation, so that's why they give different results.
upvoted 0 times
...
Eleonora
1 months ago
I think the filter is applied before the table calculation, that's why they give different results.
upvoted 0 times
...
...
Lasandra
2 months ago
But what if the LOD expression itself is not correctly set up? That could also be a reason for the difference in results.
upvoted 0 times
...
Yasuko
2 months ago
I agree with Carey, the order of operations could be affecting the results.
upvoted 0 times
...
Carey
2 months ago
I think the LOD expression might give different results because the filter is applied before the Table calculation.
upvoted 0 times
...

Save Cancel