Tableau Exam TCC-C01 Topic 1 Question 3 Discussion

Actual exam question for Tableau's TCC-C01 exam

Question #: 3
Topic #: 1

[All TCC-C01 Questions]

A client wants to flag orders that have sales higher than the regional average.

Which calculated field will produce the required result?

A[Sales]
>
{ FIXED [Order ID] : SUM([Sales]) }

B{ FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : SUM([Sales]) }

C{ FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

D{ FIXED [Order ID] : SUM([Sales]) }
>
{ INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

Show Suggested Answer

Suggested Answer: C

To flag orders with sales higher than the regional average, the correct calculated field would compare the sum of sales for each order against the average sales of all orders within the same region:

Correct Formula: { FIXED [Order ID] : SUM([Sales]) } > { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

This calculation uses a Level of Detail (LOD) expression:

The left part of the formula { FIXED [Order ID] : SUM([Sales]) } calculates the total sales for each individual order.

The right part { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) } calculates the average sales per order within each region.

The > operator is used to compare these two values to determine if the sales for each order exceed the regional average.

Reference This formula utilizes Tableau's LOD expressions to perform complex comparisons across different dimensions of the data, as explained in Tableau's official training materials on LOD calculations.

by Sina at Nov 19, 2024, 12:27 PM

Limited Time Offer

25%

15 days ago

I think the correct answer is C.

upvoted 0 times

...