How Many Data Types Are Available in Tableau?

Working with data in Tableau starts with one fundamental building block: the data type. Getting this right is the difference between a dashboard that works flawlessly and one that causes constant headaches. We'll walk through every data type available in Tableau, what it means, and how to use it correctly for accurate and effective analysis.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Do Data Types Matter So Much?

Assigning a data type tells Tableau how to interpret and handle the information in each column of your data source. Think of it like giving instructions. If you tell Tableau a column contains numbers, it knows it can perform calculations like adding them up or finding the average. If you tell it a column contains text, it knows it can't mathematically sum customer names but can split or combine them.

Accurate data types are essential for several reasons:

• Data Integrity and Accuracy: Prevents errors, like trying to get the average of a list of zip codes or summing up order IDs. The right data type ensures calculations are only performed on fields where it makes sense.
• Full Functionality: Many of Tableau’s features are data-type specific. You can only use date functions on a date field, and you can only build map visualizations with fields assigned a geographic role.
• Correct Visualizations: Using a date as a simple text string prevents you from using Tableau’s powerful date hierarchies (drilling down from year to quarter to month). A numeric profit ratio stored as a string can't be used to create a bar chart showing performance.
• Performance: Using the most appropriate and efficient data type (like a whole number instead of a decimal where possible) can optimize your dashboard's performance by making queries run faster.

Getting your data types set up correctly from the very beginning saves an enormous amount of time and prevents misleading analyses down the road.

The Main Tableau Data Types Explained

Tableau recognizes a core set of data types, each represented by a small icon next to the field name in the Data pane. Let's break down each one.

1. Text (String)

Icon: Abc

This is one of the most common data types. It consists of any sequence of zero or more characters. Essentially, if it's text, it's a string.

• Examples: Customer Names ("John Smith"), Product Categories ("Office Supplies"), Region ("West"), Order IDs ("CA-2023-152156"), and even numbers you never want to add up, like Zip Codes ("90210").
• Typical Uses: Text values are perfect for labels, headers, categories in charts, and detailed descriptions in tooltips. You use them as dimensions to slice and dice your numerical data.
• A Quick Tip: Always set fields like zip codes, phone numbers, and customer IDs to a string data type. While they are made of numbers, you would never want to perform a sum or average on them. Treating them as strings prevents accidental mathematical operations.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

2. Number (Decimal and Whole)

Icon: #

Numerical values represent quantitative data - the numbers you want to measure and calculate. Tableau manages two main categories of numbers, though they share the same icon.

• Decimal (float): Numbers with a fractional component. This is the data type for most financial data. For example: Sales ($49.99), Profit Ratio (0.15), or AOV ($123.45).
• Whole (integer): Numbers without a fractional component. This is used for counts and quantities. For example: Quantity Sold (5), Number of Customers (1,204), or Page Views (50,000).

Typical Uses: Numerical fields are the foundation of your key performance indicators (KPIs). They are typically used as measures, meaning Tableau can aggregate them using functions like SUM, AVG (average), MIN, and MAX. Your revenue, costs, engagement metrics, and conversion rates will all be number data types.

3. Date

Icon: A calendar symbol

This data type is specifically for fields containing dates without any time information. Tableau is brilliant at handling dates and automatically recognizes many common formats like MM/DD/YYYY (07/26/2024), DD-Mon-YYYY (26-Jul-2024), and others.

• Examples: Order Date, Ship Date, Subscription Start Date.
• Typical Uses: Date fields are essential for time-series analysis - how did sales trend over the last year? What was our website traffic last quarter? Once a field is set as a date, Tableau lets you easily group or drill down by year, quarter, month, week, and day.

4. Date & Time

Icon: A calendar symbol with a clock

This is a more granular version of the Date type, containing both calendar date and time-of-day information.

• Examples: A system timestamp for a website visit ("2024-07-26 14:35:10"), a server log entry, or a specific transaction time.
• Typical Uses: This is perfect for analyzing patterns that occur at specific times of the day. For example, an e-commerce store might use it to see which hours have the highest sales volume, or a support team might track response times down to the minute.

5. Boolean (True/False)

Icon: T|F

A boolean data type has only two possible values: true or false. In real-world data, this can also be represented by 1s and 0s.

• Examples: You often create boolean fields yourself using a calculated field, such as [Profit] > 0, which will return True for every profitable sale and False otherwise. Other examples include "Is Active?" or "Subscribed?".
• Typical Uses: Booleans are extremely powerful for filtering and segmenting your data. You can easily drag a boolean field to the Filters shelf to show only the "True" values (e.g., show only profitable orders) or use it on the Color shelf to quickly highlight different segments of a visualization.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

6. Geographic

Icon: A globe

This isn't a "data type" you select in the same way as the others, but rather a role you assign to a text or number field. When you assign a geographic role to a field, Tableau generates latitude and longitude coordinates for each location, allowing you to build map visualizations.

• Examples: Country, State/Province, City, ZIP Code/Postcode, County, Airport.
• Typical Uses: The primary use is to create maps. You can plot store locations, visualize sales by region, or analyze population data by state. Tableau automatically generates the necessary geographic data when it recognizes a field name like "State" or "Country."

How to View and Change Data Types in Tableau

Tableau does a pretty good job of guessing the correct data type when you first connect to your data, but it's not always perfect. It's a best practice to always review your data types immediately after connecting a new source.

You can check and change data types in two main places:

1. On the Data Source Page

This is the first screen you see after connecting your data. It shows a grid-style preview of your data.

• Look at the column headers in the grid.
• Above each column name, you will see a small icon (Abc, #, calendar, etc.) representing the current data type.
• To change it, simply click on the icon and select the correct data type from the drop-down menu that appears.

This is the best place to make changes, as it applies them before you start building any worksheets.

2. In the Data Pane

Once you are in a worksheet view, you can also change data types in the Data pane on the left side of the screen.

• Find the data field you want to modify under the "Tables" section.
• Click the data type icon to the left of the field name.
• A menu will appear allowing you to select a new data type.

You can also right-click on the data field, select "Change Data Type," and choose from the list.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Common Challenges with Data Types and Quick Fixes

Even with a good understanding, you'll eventually run into a few common issues. Here’s how to handle them.

Challenge: Numbers That Should be Text

• Problem: Tableau may see a column like "Zip Code" and classify it as a number (#) because it only contains numeric characters. If you then mistakenly drag this onto a worksheet, Tableau might try to SUM up the zip codes, which is meaningless.
• Fix: Manually change the data type for such fields (Zip Codes, Order IDs, Phone Numbers) to "String" (Abc). This ensures they are treated as unique identifiers or labels, not as numbers to be aggregated.

Challenge: Dates Stored as Text

• Problem: Sometimes, dates are stored in non-standard formats that Tableau doesn't automatically recognize, so it classifies the field as a string. Without the proper "Date" type, you can't use date hierarchies or time-series functions.
• Fix: You can often just change the data type to "Date" and Tableau will try its best to read it. If that doesn't work, you'll need the powerful DATEPARSE() function. This function lets you specify the exact format of your text string so Tableau can convert it correctly. For example, if your date looks like "26.07.2024", you would create a calculated field with: DATEPARSE('dd.MM.yyyy', [YourDateStringField])

Challenge: Mixed Data Types in a Single Column

• Problem: In messy data sources (like some Excel files), a single column might contain both numbers and text (e.g., most rows say "100" but a few say "N/A"). Tableau will usually default the entire column to the most accommodating type, which is text ("String"). This prevents you from doing any math on the valid numbers.
• Fix: The best solution is to clean the data in the source itself before bringing it into Tableau. If that's not possible, you'll need to create a calculated field in Tableau to isolate and convert the numbers. You could write an expression like INT(REGEXP_EXTRACT([YourField], '(\\d+)')) to pull out only the digits and convert them to an integer.

Final Thoughts

Mastering data types is a non-negotiable step toward becoming proficient in Tableau. It’s a foundational concept that influences everything else you do, from building simple charts to developing complex calculations and interactive dashboards. Taking a few moments upfront to review and correct your data types will save hours of confusion later and ensure your analysis is both accurate and insightful.

While Tableau is an incredibly powerful tool for those willing to learn its intricacies, sometimes you just need answers without the steep learning curve. At Graphed, we're focused on removing that complexity. By connecting directly to your marketing and sales platforms, we use AI to interpret your data automatically, saving you the manual work of setting data types and building reports from scratch. Instead of learning functions and configurations, you can just ask a question like, "Show me our sales trend from Google Analytics for the last quarter as a line chart," and get a live, interactive visualization in seconds with Graphed.