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".
Right-click the field and choose "Aliases" to assign text labels to the numeric values.
Drag the field from the Measures section to the Dimensions section in the Data pane.
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
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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .