Changing data types
Depending on the data source and connection, Tableau tries to determine the field data type. Most often, the field data types are identified correctly; sometimes, however, changing data types becomes necessary.
Getting ready
We will use the sample superstore sales saved data source for this exercise. Open a new worksheet and connect to the Sample – Superstore Sales (Excel) data source.
How to do it....
Once the sample file is loaded on the worksheet, perform the following steps to convert data types:
- In the Dimensions pane, right-click on Order Date.
- You'll notice some data types in Tableau: Number, String, and Date. Date & time is ...
Get Tableau: Creating Interactive Data Visualizations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
