What a calculated field does
A calculated field in Tableau is a new column you create using a formula, built from data you already have in your spreadsheet or database. Instead of adding the calculation to your original data file, Tableau does the math inside the program itself — so your source file stays unchanged, but your visualizations can show the result.
The simplest example: if your data has a "Price" column and a "Quantity" column, you can create a calculated field called "Total Sale" that multiplies them together for every row. Tableau then treats that calculated field like any other column — you can drag it into charts, filter by it, or sort by it.
Calculated fields save time because you do not have to go back to your spreadsheet, add a new column, recalculate everything, and re-upload the file each time you want a different calculation. You build it once in Tableau and it updates automatically when your data refreshes.
Key Takeaways
- A calculated field is a formula you write inside Tableau that creates a new column of results without changing your original data file.
- You access the calculated field dialog by right-clicking the data pane on the left side of your screen and selecting "Create Calculated Field".
- Tableau formulas use functions like SUM(), AVG(), and IF() — you can combine them to perform math, comparisons, or text operations on your existing columns.
- Once created, a calculated field appears in your data pane and behaves like any other column — you can drag it into visualizations, filter by it, or use it in other formulas.
Opening the calculated field dialog
Start with your data source already connected to Tableau. On the left side of your screen, you will see the data pane — a panel showing all your columns (called "fields" in Tableau). Right-click anywhere in that pane and select "Create Calculated Field" from the menu that appears.
A dialog box will open with two main areas: a text field at the top where you type a name for your new field, and a larger text area below where you write the formula. The name should describe what the field calculates — "Total Revenue" or "Days Since Purchase" are clearer than "Calc1".
As you type your formula, Tableau shows you a list of available functions and fields you can use. If you make a syntax error (a typo or a missing parenthesis), Tableau will highlight it in red and tell you what is wrong before you save.
Writing a basic formula
Tableau formulas work like spreadsheet formulas. If you want to add two columns together, you write [Column A] + [Column B]. The square brackets tell Tableau you are referring to an existing field. If you want to multiply, use an asterisk: [Price] * [Quantity]. Division uses a forward slash: [Total] / [Count].
You can also use built-in functions. SUM() adds up all values in a column. AVG() finds the average. COUNT() counts how many rows exist. MAX() and MIN() find the highest and lowest values. To use one, put the field name in parentheses: SUM([Sales]) or AVG([Rating]).
A practical example: if your data has a "Revenue" column and a "Cost" column, you could create a calculated field called "Profit" with the formula [Revenue] - [Cost]. When you click OK, Tableau calculates profit for every row in your data and adds it to your data pane as a new field you can use in charts.
Using IF statements for conditional logic
Sometimes you need a calculation that changes based on a condition. The IF() function lets you do this. The structure is IF([condition], [value if true], [value if false]).
For example, suppose you have a "Sales" column and you want to flag any sale over $1,000 as "High" and anything else as "Low". Your formula would be IF([Sales] > 1000, "High", "Low"). Tableau checks each row: if sales are greater than 1,000, it shows "High"; otherwise it shows "Low".
You can nest IF statements — put one inside another — to handle multiple conditions. IF([Sales] > 5000, "Premium", IF([Sales] > 1000, "High", "Low")) creates three categories. Tableau reads from the inside out, so it checks the inner IF first, then the outer one.
Common functions beyond the basics
ROUND() rounds a number to a set number of decimal places: ROUND([Price], 2) rounds to two decimals. LEN() counts characters in text: LEN([Name]) tells you how many letters are in a name field. UPPER() and LOWER() convert text to uppercase or lowercase.
DATEDIFF() calculates the gap between two dates. DATEDIFF('day', [Start Date], [End Date]) tells you how many days passed between them. You can use 'day', 'month', 'year', or other time units depending on what you need.
CONCATENATE() joins text fields together. CONCATENATE([First Name], " ", [Last Name]) combines a first and last name with a space between them. This is useful when your data has separate columns but you want to display them as one field.
Where your calculated field appears and how to use it
Once you click OK, your new calculated field shows up in the data pane on the left, usually in a section labeled "Measures" or "Dimensions" depending on what type of data it contains. You can now drag it into your visualizations just like any other field — drop it on a shelf to add it to a chart, or drag it to the Filters area to filter your data by that calculation.
If you need to edit the formula later, right-click the field name in the data pane and select "Edit Calculated Field". The dialog opens again with your formula ready to change. Any charts using that field update automatically when you save your changes.
You can also use a calculated field inside another calculated field. If you created a "Profit" field, you could create a second field called "Profit Margin" with the formula [Profit] / [Revenue]. Tableau chains the calculations together without any extra work from you.
Troubleshooting when your formula does not work
If Tableau shows an error message, check three things first: square brackets around field names, matching parentheses, and correct spelling of function names. [Sales] works; Sales without brackets does not. SUM([Revenue]) works; SUM[Revenue] with square brackets instead of parentheses does not.
If your formula saves but the results look wrong, the issue is usually the logic, not the syntax. Test with a small example: create a straightforward formula like [Price] * 2 and check that it doubles your prices correctly. Once that works, build toward your actual formula step by step.
If you see a message about "mismatched data types", Tableau is telling you that you are trying to do math on text, or text operations on numbers. You cannot add a number column to a text column. If you need to convert between types, use functions like INT() to convert text to a number, or STR() to convert a number to text.
Frequently Asked Questions
Can I use a calculated field in another calculated field?
Yes. Once you create a calculated field, it appears in your data pane and you can reference it in any new formula using square brackets, just like an original column. This is useful for building complex calculations step by step — create a straightforward field first, then use it in a more advanced one.
Does creating a calculated field change my original data file?
No. Calculated fields exist only inside Tableau. Your original spreadsheet or database stays exactly as it was. If you want to save the calculated results back to your file, you would need to export the data from Tableau separately.
What is the difference between a calculated field and a parameter?
A calculated field performs a formula on your data — it creates a new column of results. A parameter is a value you set manually (like a number or date) that you can use in formulas or filters to change what your visualization shows. Parameters do not calculate from your data; you control them directly.
Can I use calculated fields with aggregated data?
Yes, but the behavior depends on what you are aggregating. If you drag a calculated field onto a chart shelf alongside a dimension, Tableau aggregates the calculation — usually by summing it. You can change the aggregation by clicking the field on the shelf and selecting a different option like Average or Count.
What happens to a calculated field if I add new rows to my data?
The formula applies automatically to the new rows. When your data refreshes in Tableau, the calculated field recalculates for all rows, including new ones. You do not have to rebuild the field or update the formula.