In Tableau, a data analyst drags the numeric field Customer ID into the view and sees that it appears as a blue pill on the Rows shelf, listed under Dimensions. Which explanation best describes why Tableau categorizes this field as a dimension?
Only fields stored as strings in the data source can be dimensions; Customer ID was automatically converted to text.
A field can act as a dimension when it contains fewer than 15 distinct values; beyond that it becomes a measure.
Tableau places any numeric field on Dimensions until the user explicitly changes its default aggregation to SUM.
Dimensions describe categorical, qualitative values used to slice or group data; Customer ID, though numeric, identifies customers rather than representing a quantity to be aggregated.
Tableau assigns a field to Dimensions when the values are categorical labels that define how the data can be sliced or grouped. Customer ID is an identifier that distinguishes one customer from another; it does not represent a quantity that should be summed, averaged, or otherwise aggregated. Although the field is stored as numbers, its analytical role is qualitative. Numeric fields that convey quantitative size, amount, or magnitude-such as Sales or Profit-are placed in Measures because they are aggregated by default. The alternative statements are inaccurate: Tableau does not default numeric fields to Dimensions, does not silently convert them to text, and the number of distinct values does not determine whether a field is a dimension or measure.
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.
Why does Tableau treat Customer ID as a dimension even though it's numeric?
Open an interactive chat with Bash
Can numeric fields ever be measures in Tableau?
Open an interactive chat with Bash
How does Tableau decide if a field should be a dimension or measure?
Open an interactive chat with Bash
Why does Tableau classify Customer ID as a dimension even though it is numeric?
Open an interactive chat with Bash
Can a numeric field ever be a measure in Tableau, and how does Tableau handle it?
Open an interactive chat with Bash
What determines whether a field becomes a dimension or a measure in Tableau?
Open an interactive chat with Bash
Tableau Desktop Foundations
Understanding Tableau Concepts
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .