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%

Off

Get Premium TCC-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

MonBouj

24 days ago

Option C correctly aggregates sales at the order level and compares it to the average order sales within the region, making it the best choice for flagging orders with sales higher than the regional average.

upvoted 1 times

...

Karan

2 months ago

I'm going with B. It's the simplest solution, and sometimes simple is best. Plus, who doesn't love a good old-fashioned regional average? It's like the pumpkin spice latte of data analytics.

upvoted 0 times

...

Suzi

2 months ago

But C calculates the average sales per order ID for each region, which is what the client wants.

upvoted 0 times

...

2 months ago

Option C seems like the way to go. Fixing by Order ID to get the total sales per order, then fixing by Region to calculate the average sales per region. That should give us the required result.

upvoted 0 times