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 TDA-C01 Topic 10 Question 37 Discussion

Actual exam question for Tableau's TDA-C01 exam
Question #: 37
Topic #: 10
[All TDA-C01 Questions]

You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

Show Suggested Answer Hide Answer
Suggested Answer: B, C

To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role.Reference:The information is based on the following sources:

Use Data Roles to Validate your Data - Tableau

New in Tableau Prep: Automatically identify data quality issues with Data Roles


Contribute your Thoughts:

Ruthann
1 months ago
After staring at this question for what feels like an eternity, I just want to yell, 'Give me the darn formula already!' But I guess that's not how these exams work. *sigh*
upvoted 0 times
Latia
11 days ago
I think the answer is A) {FIXED: [Region] SUM Sales}
upvoted 0 times
...
Jacqueline
16 days ago
A) {FIXED: [Region] SUM Sales}
upvoted 0 times
...
...
Leonard
2 months ago
A) {FIXED: [Region] SUM Sales} is the way to go! It's the only one that explicitly mentions the Region dimension, which seems important for this question.
upvoted 0 times
Twila
8 days ago
D) {FIXED: [Region] SUM Sales} is the best option because it considers the Region dimension in the calculation.
upvoted 0 times
...
Tamra
21 days ago
C) I agree, {FIXED: [Region] SUM Sales} seems like the correct choice since it includes the Region dimension.
upvoted 0 times
...
Jerry
29 days ago
B) I think {FIXED: [Region] SUM Sales} makes sense. It specifies the Region dimension for the calculation.
upvoted 0 times
...
Kassandra
1 months ago
A) {FIXED: [Region] SUM Sales} is the way to go! It's the only one that explicitly mentions the Region dimension, which seems important for this question.
upvoted 0 times
...
...
Huey
2 months ago
I'm going with D) {FIXED: TOTAL (Sales)}. It seems logical to use the TOTAL function to get the grand total, but I'm not 100% confident in my choice.
upvoted 0 times
...
Elbert
2 months ago
I think the answer is B) {FIXED: SUM Sales}. It looks like the simplest way to get the grand total, but I'm not sure if it's the best approach.
upvoted 0 times
...
Fannie
2 months ago
The correct answer is C) {Fixed: [Region]: TOTAL Sales}. This expression calculates the grand total of sales for all regions by fixing the Region dimension and then calculating the total sales.
upvoted 0 times
Goldie
1 months ago
I agree, that expression calculates the grand total of sales for all regions by fixing the Region dimension and then calculating the total sales.
upvoted 0 times
...
Nickole
1 months ago
I think the answer is C) {Fixed: [Region]: TOTAL Sales}
upvoted 0 times
...
...
Maurine
2 months ago
But wouldn't using the Region in the LOD expression be more accurate for calculating the grand total?
upvoted 0 times
...
Fernanda
2 months ago
I disagree, I believe the correct answer is D) {FIXED: TOTAL (Sales)}
upvoted 0 times
...
Maurine
2 months ago
I think the answer is A) {FIXED: [Region] SUM Sales}
upvoted 0 times
...

Save Cancel