Tableau Desktop Foundations Practice Question

You have a Tableau worksheet that displays a single aggregated value for total sales. What is the expected result when you drag a "Region" dimension into the "Columns" shelf?

A filter dialog for "Region" will open, prompting you to select which regions to display.
The single sales value will be broken down, showing a separate aggregated sales value for each region.
The aggregation for sales will automatically change from SUM to AVERAGE to account for the new dimension.
The total sales value will be repeated for each region in the view.

Report Issue

Answer Description

The correct answer is that the single sales value will be broken down to show a separate value for each region. In Tableau, measures are aggregated to the level of detail defined by the dimensions in the view. When a view contains only an aggregated measure, like SUM(Sales), the level of detail is the entire data source, resulting in a single value. Adding a dimension, like 'Region', changes the level of detail. This action partitions or 'slices' the measure, causing Tableau to compute the SUM(Sales) for each individual region.

The aggregation type (e.g., SUM) does not automatically change when a dimension is added; this requires a manual change by the user.
The total value is not repeated for each member of the dimension; rather, it is subdivided among them.
A filter dialog appears when a field is dragged to the Filters card, not to the Columns or Rows shelves.

Ask Bash

Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.