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

AThe market filter is not correctly set up

BThe LOD expression is not correctly set up

CThe table calculation is not correctly set up

DThe filter is applied before the Table calculation is performed

Show Suggested 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

1 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

1 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

5 days 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

13 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

18 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

25 days ago

User 2: Yeah, that could be the reason for the different results.

upvoted 0 times

...

Chauncey

1 months ago

User 1: I think the market filter might not be set up correctly.

upvoted 0 times

...

Quentin

2 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

1 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

1 months 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

23 days ago

But what if the LOD expression or table calculation is not set up correctly?

upvoted 0 times

...

Helaine

23 days ago

Yeah, that makes sense. So option D is probably the correct answer.

upvoted 0 times

...

Jannette

1 months 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

2 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

3 months ago

I think the LOD expression might give different results because the filter is applied before the Table calculation.

upvoted 0 times

...