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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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:


by Georgene at Sep 14, 2024, 10:44 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Tijuana
3 months 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
3 months 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
Erasmo
2 months ago
It's important to double-check the configuration of the table calculation to ensure accurate results for percent of total sales.
upvoted 0 times
...
Brigette
2 months 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
2 months 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
3 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
Alyce
2 months ago
User 3: Option A seems like the right choice then.
upvoted 0 times
...
Delmy
3 months ago
User 2: Yeah, that could be the reason for the different results.
upvoted 0 times
...
Chauncey
3 months ago
User 1: I think the market filter might not be set up correctly.
upvoted 0 times
...
...
Quentin
3 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
3 months 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
3 months ago
Maybe the market filter is not correctly set up, causing the difference in results.
upvoted 0 times
...
Alease
3 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
4 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
Maxima
2 months ago
That's a good point. It could also be because of that. We should double check the setup.
upvoted 0 times
...
Sage
2 months ago
But what if the LOD expression or table calculation is not set up correctly?
upvoted 0 times
...
Helaine
3 months ago
Yeah, that makes sense. So option D is probably the correct answer.
upvoted 0 times
...
Jannette
3 months ago
Yes, option D mentions that the filter is applied before the table calculation is performed.
upvoted 0 times
...
Verona
3 months ago
I think the filter is applied before the table calculation, so that's why they give different results.
upvoted 0 times
...
Eleonora
3 months ago
I think the filter is applied before the table calculation, that's why they give different results.
upvoted 0 times
...
...
Lasandra
4 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
4 months ago
I agree with Carey, the order of operations could be affecting the results.
upvoted 0 times
...
Carey
4 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