ExamGecko
Question list
Search
Search

List of questions

Search

Question 85 - Desktop Certified Associate discussion

Report
Export

Why might this LOD expression for percent of total sales give different results than a table calculation for percent of total sales?

Larger image

A.
The market filter is not correctly set up
Answers
A.
The market filter is not correctly set up
B.
The LOD expression is not correctly set up
Answers
B.
The LOD expression is not correctly set up
C.
The table calculation is not correctly set up
Answers
C.
The table calculation is not correctly set up
D.
The filter is applied before the Table calculation is performed
Answers
D.
The filter is applied before the Table calculation is performed
Suggested answer: D

Explanation:

As per the Tableau order of operation, dimension filter is applied before table calculation is computed. However, fixed LOD is executed before the dimension filter. That's why total sales are showing different results.

Reference - https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

asked 23/09/2024
EduBP srl De Sanctis
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first