After connecting to a CSV file, Tableau displays the Sales_Amount field with the Abc data type icon, preventing you from summing the values. Which action correctly changes the field so that you can aggregate it numerically?
Right-click the field in the Data pane, choose Change Data Type, and select Number (decimal).
From the worksheet menu, select Analysis > Convert Measures to Dimensions.
Drag the field onto Measure Names so Tableau automatically converts it to a measure.
Edit the field's default number format and set a currency format.
The Abc icon indicates a string data type. To make Tableau treat the values as numbers you must explicitly change the data type. This is done by right-clicking the field (or clicking the icon) in the Data pane, choosing Change Data Type, and selecting a numeric option such as Number (decimal). Dragging the field to a shelf, converting measures to dimensions, or editing the default number format does not alter the underlying data type, so these steps would not enable numeric aggregation.
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.
What does the Abc icon in Tableau indicate?
Open an interactive chat with Bash
How do you change a field's data type in Tableau?
Open an interactive chat with Bash
Why doesn't editing the field's default number format change its data type?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
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 .