Tableau has classified the numeric field "Product ID" as a Number (measure). You need Tableau to treat this field as a text identifier so it will never be summed, averaged, or otherwise aggregated. Which action will change the data type of the field from Number to String?
Create a new calculated field using STR([Product ID]) to convert the values to text.
Click the data-type icon next to the field name in the Data pane and select "String".
Drag the field from the Measures section to the Dimensions section in the Data pane.
Right-click the field and choose "Aliases" to assign text labels to the numeric values.
Clicking the data-type icon (the green # symbol) next to the field name and selecting "String" changes the data type from Number to String. Tableau then treats the field as text, moves it to Dimensions, and prevents all numeric aggregations. Converting the field to a dimension without changing its type stops aggregation but leaves it as a numeric data type. Creating a calculated STR() field works but produces a duplicate field. Aliases only rename displayed values and do not affect the data type.
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 is the role of the data-type icon in Tableau?
Open an interactive chat with Bash
What happens when you move a field from Measures to Dimensions in Tableau?
Open an interactive chat with Bash
How does the STR() function work in Tableau for converting data types?
Open an interactive chat with Bash
What is the difference between changing a field's data type and moving it between Measures and Dimensions in Tableau?
Open an interactive chat with Bash
Why is using the STR() function to convert numeric values to text not ideal in this case?
Open an interactive chat with Bash
What are Aliases in Tableau, and why don't they affect a field's 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 .