Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Tableau Discussions

Exam TDA-C01 topic 1 question 14 discussion

Actual exam question from Tableau's TDA-C01
Question #: 14
Topic #: 1
[All TDA-C01 Questions]

You have the following dataset.

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

  • A. { FIXED [Region]: SUM(Sales) }
  • B. { FIXED : SUM(Sales) }
  • C. { FIXED [Region]: TOTAL(Sales) }
  • D. { FIXED : TOTAL(Sales) }
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Eden666 at July 25, 2023, 8:03 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Benzlover
1 month ago
Selected Answer: B
To calculate the grand total of all the regions, you should use the following Level of Detail (LOD) expression: **B. { FIXED : SUM(Sales) }** This expression calculates the sum of sales across all regions, regardless of any dimensions in the view.
upvoted 1 times
...
MonBouj
1 month, 1 week ago
Selected Answer: B
B. { FIXED : SUM(Sales) } Leaving it blank means that it shouldn't be grouped by or fixed on a particular dimension. The calculation will simply compute total sales for the entire database. This is the least granular calculation for total sales
upvoted 1 times
...
Dk1984
9 months, 3 weeks ago
Selected Answer: B
B is correct answer
upvoted 2 times
...
fat
10 months ago
Why is it not A?
upvoted 3 times
...
Steffi160
10 months, 1 week ago
Selected Answer: B
B is correct answer
upvoted 2 times
...
Vedjha
11 months, 1 week ago
B is correct answer
upvoted 2 times
...
Vedjha
11 months, 1 week ago
answer is correct
upvoted 1 times
...
maheshadithya12345678
11 months, 1 week ago
BECAUSE TOTAL CANNOT BE USED WITH SALES TOTAL(SUM(SALES))
upvoted 1 times
...
Eden666
11 months, 2 weeks ago
Selected Answer: D
Why is not D
upvoted 1 times
CollectiveConsciousness
11 months, 1 week ago
You can not use table calculations in fixed calculations. If you tried to enter that calculation in Tableau it would tell you "LODs can not be used with table calcs or attribute functions"
upvoted 3 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in

Claim Offer Now
286 people claimed it in the last 6 hours