ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 13 - TDA-C01 discussion

Report
Export

You have the following dataset.

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

A.
{FIXED: [Region] SUM Sales}
Answers
A.
{FIXED: [Region] SUM Sales}
B.
{FIXED: SUM Sales}
Answers
B.
{FIXED: SUM Sales}
C.
{Fixed: [Region]: TOTAL Sales}
Answers
C.
{Fixed: [Region]: TOTAL Sales}
D.
{FIXED: TOTAL (Sales)}
Answers
D.
{FIXED: TOTAL (Sales)}
Suggested answer: D

Explanation:

To calculate the grand total of all the regions, you need to use a Level of Detail (LOD) expression that ignores any dimensions in the view and returns the total sum of sales. The FIXED keyword allows you to specify the level of detail for the calculation, and the TOTAL function returns the sum of all values in the expression. Therefore, the correct LOD expression is {FIXED: TOTAL (Sales)}.

Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL

asked 23/09/2024
Robinson Santos
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first