What Are Fields in Tableau?

If you're starting with Tableau, the term "field" is one of the first things you'll encounter, and understanding it is foundational to everything you'll do. Think of fields as the basic building blocks for every analysis and chart you create. This article breaks down exactly what fields are, the different types you'll work with, and how to use them to start turning your raw data into meaningful visualizations.

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

What Exactly is a Field in Tableau?

In the simplest terms, a field in Tableau is a column of data from your source file. When you connect Tableau to a CSV, an Excel spreadsheet, or a database, Tableau scans your data and lists each column as a separate field in the "Data" pane, which you'll find on the left side of your worksheet.

For example, if you have a spreadsheet with sales data, you might have columns like:

• Order ID
• Order Date
• Customer Name
• Region
• Product Category
• Sales
• Profit

Each one of these columns - Order ID, Order Date, Sales, etc. - becomes an individual "field" in Tableau. These are the ingredients you'll drag and drop onto your canvas (or "view") to build charts, graphs, and tables. Tableau is smart enough to automatically classify these fields into different types based on the kind of data they contain, which brings us to the most important distinction you need to learn.

The Two Main Types of Fields: Dimensions vs. Measures

Tableau’s primary job is to help you analyze numbers (Measures) broken down by categories (Dimensions). It automatically separates your fields into these two groups, which you'll see in the Data pane. Understanding this separation is the single most important concept for a new Tableau user.

Dimensions: The "Who, What, Where, and When"

Dimensions are fields that contain qualitative, categorical information. They are the descriptive labels you use to slice, dice, and organize your numerical data. Think of them as the context for your analysis.

• What they are: Text, dates, or geographical data.
• What they do: Set the level of detail, or "granularity," of your view. When you add a dimension to the view, Tableau creates labels or headers for each unique member of that field.
• Common Examples: Customer Name, Product Category, Order Date, Region, State. You can't really do math on "Product Category." Instead, you use it to group your data.

In Tableau, dimensions are typically represented by a blue pill or a blue icon in the Data pane. The blue color signifies that the field is being treated as discrete. A discrete field has values that are separate and distinct. For example, the values in the "Region" field - 'North', 'South', 'East', 'West' - are individual, separate labels. When you drag a discrete field onto the Columns or Rows shelf, it creates headers for each value.

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

Measures: The "How Much and How Many"

Measures are fields that contain quantitative, numerical information. These are the fields you can perform mathematical calculations on, like summing them up, finding the average, or counting them.

• What they are: Numbers you can measure.
• What they do: Provide the numerical values for your charts. When you add a measure to the view, Tableau automatically aggregates it (usually with a SUM).
• Common Examples: Sales, Profit, Quantity, Discount, Salary. These are all things you can aggregate.

Measures are usually represented by a green pill or a green icon. Green signifies that the field is being treated as continuous. A continuous field has values that can fall anywhere within a range. For example, a "Sales" value could be $100.51, $100.52, or any value in between. When you drag a continuous field to the Columns or Rows shelf, it creates a continuous axis.

Putting It All Together: A Simple Example

Let's say you want to see your total sales for each product category.

1. You would drag the Product Category dimension onto the Rows shelf. Tableau creates a row for each category (e.g., "Furniture," "Office Supplies," "Technology").
2. You would then drag the Sales measure onto the Columns shelf. Tableau creates a horizontal axis and draws a bar for each category, with the length of the bar representing the sum of sales for that category.

Just like that, you've used a dimension to slice your data and a measure to provide the values. This simple action is the basis for nearly every chart you'll build.

Beyond the Basics: Other Important Field Types

While Dimensions and Measures are the main players, Tableau has other powerful field types that allow for more complex and customized analysis. Once you're comfortable with the basics, these are the next ones to learn.

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

Calculated Fields

A calculated field is a new field you create by defining a formula based on your existing fields. It's just like adding a formula to a new column in an Excel sheet. You can use them for everything from simple arithmetic to complex logical statements.

To create one, right-click anywhere in the Data pane and select "Create Calculated Field."

Example 1: Profit Ratio Let's say your data has Sales and Profit, but not a Profit Ratio. You can easily create it with a calculated field using this formula:

SUM([Profit]) / SUM([Sales])

This creates a new measure called "Profit Ratio" that you can use just like any other field. You can now analyze which product categories or regions are most profitable.

Example 2: Grouping with Logic You can also create new dimensions with calculations. For instance, you could create a field called Is Profitable? to quickly segment orders:

IF SUM([Profit]) > 0 THEN 'Profitable' ELSE 'Unprofitable' END

This creates a new dimension that will categorize every row in your data as either "Profitable" or "Unprofitable." You could drag this new field to the Color mark to instantly see which bars on your chart represent profitable or unprofitable sales.

Calculated fields are identified by a small equals sign (=) next to their icon (e.g., #= for a measure, Abc= for a dimension).

Sets

A set is a custom field that allows you to isolate and group a subset of your data based on certain conditions. You can think of it as creating a specific group of interest, like "Top 10 Customers" or "Products Purchased in the Last 30 Days."

Sets divide your data into two groups: IN (members that meet the criteria) and OUT (members that don't). This is incredibly useful for comparative analysis.

Example: Top Customers by Sales You could right-click the Customer Name field, choose "Create," and then "Set." From there, you could define a set of your top 10 customers based on the sum of sales. Tableau creates a new Top Customers Set field. If you drag this onto the view, you can compare the buying behavior, product mix, or profitability of your top customers (the IN group) versus everyone else (the OUT group).

Parameters

A parameter is a dynamic placeholder value that an end-user of your dashboard can change. It lets you add interactivity and enables "what-if" analysis without altering your original data source. Parameters are just values, they don't do anything on their own until you link them to a filter, a calculated field, or a reference line.

Example: Dynamic Sales Goal Imagine you want to see which of your sales reps have met a specific sales target, but that target changes quarterly. Instead of hard-coding the target into a calculation, you can create a parameter called Sales Target.

1. Create a parameter (e.g., Sales Target) and set it as a number.
2. Create a calculated field called Met Target? that references the parameter:

SUM([Sales]) > [Sales Target]

1. Use the Met Target? field to color your visuals. On your dashboard, show the parameter control. Now, anyone viewing the dashboard can type in a new number for the Sales Target, and the chart will instantly update to show who is above or below the new goal.

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

Working with Fields in the Tableau Workspace

Now that you know what the different fields are, how do you actually use them?

The Data Pane

This is your command center on the left of the screen. All available fields are listed here, neatly organized under Dimensions and Measures. If you're connected to a source with multiple tables, they'll be grouped by table.

Dragging and Dropping to Shelves

The core of building in Tableau is dragging fields from the Data pane onto different "shelves" in the workspace. The main shelves are:

• Columns & Rows Shelves: These determine the structure of your chart - its x-axis and y-axis. Placing a dimension here creates headers, while placing a measure creates axes.
• Marks Card: This shelf controls the visual details of your chart. You can drag fields onto properties like:
• Filters Shelf: Drag any field here to open a filtering menu. This allows you to include or exclude specific values to narrow down the data shown in your view.

Changing Field Properties

You can quickly modify how a field behaves by right-clicking its pill in the view. A common action is changing a measure's aggregation. For example, instead of seeing the Sum of Sales, you might want to see the Average Sales. Just right-click the SUM(Sales) pill, go to "Measure (Sum)," and select "Average."

From this context menu, you can also format the field (e.g., add a dollar sign and change decimal places), convert it from discrete to continuous, or switch it from a dimension to a measure if Tableau classified it incorrectly.

Final Thoughts

Understanding fields is the key to unlocking Tableau's power. It all starts with the basic difference between Dimensions (the context) and Measures (the numbers). Once you master that relationship, you can move on to use calculated fields, sets, and parameters to customize your analysis, add interactivity, and answer far more complex business questions.

Mastering tools like Tableau is a fantastic skill, but sometimes you don't have time to create a new dashboard or run complex calculations just for one answer. For those times, we built Graphed. Our platform connects directly to your data sources and allows you to build real-time reports and dashboards just by describing what you want to see. Instead of dragging and dropping fields, you simply ask, "Show me last month's sales by product category," and get an answer in seconds.