Tableau-Desktop-Found Exploring and Analyzing Data Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  Create a calculated field: SUM(Sales) / SUM(Total Sales).

  Why it's wrong here

  This approach is unnecessarily complex and prone to errors. You would need to use a level-of-detail expression to get the total sales, which is overkill for a simple percentage calculation when built-in features exist that handle partitioning and total calculations automatically with just a few clicks.

• ✓

  Right-click the Sales measure, select 'Quick Table Calculation', and choose 'Percent of Total'.

  Why this is correct

  Quick Table Calculations are designed for exactly this scenario. They automatically handle the mathematical complexity of dividing the regional sum by the global sum. This is the standard, most efficient workflow in Tableau for deriving relative proportions without writing custom code or complex level-of-detail logic.

• ✗

  Change the aggregation of Sales from SUM to Percent.

  Why it's wrong here

  Tableau does not have a 'Percent' aggregation option. Aggregations available include Sum, Average, Median, Min, Max, and Count. Selecting a non-existent feature is impossible, and even if it existed, it would not provide the context required to calculate a percentage relative to the total.

• ✗

  Filter out all regions except the one you are calculating for.

  Why it's wrong here

  Filtering removes data from the view, making it impossible to calculate a percentage 'of total' because the total itself is now missing. You need the full dataset to establish the baseline for the percentage calculation. Filtering before calculating will result in 100% for the single remaining region.