Was this page helpful?
Yes No
Have a comment? Please leave it here.Thanks for your feedback!

Home > 

Design Views and Analyze Data > Advanced Analysis > Transform Values with Table Calculations

Transform Values with Table Calculations

A table calculation is a transformation you apply to the values for a measure in the view.

You can use table calculations for a variety of purposes, including:

Table calculations are available as you work with views in Tableau Desktop and also as you edit views in Tableau Server or Tableau Online.

Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the view and do not consider any measures or dimensions that are filtered out of the view.

Note: The “table” is determined by the dimensions in the view—not the tables in your data source. Also, a “table calculation” is an entirely different thing than a calculated field. For information on calculated fields, see Calculated Fields.

Calculation Assistance

Tableau provides visual cues to help you understand the effects of your decisions as you work with table calculations. You can toggle these aides on or off by clicking Show calculation assistance in the Table Calculation dialog box.

What is a Table Calculation?

Quick Table Calculations

Choose Your Approach to Table Calculations

Create a Table Calculation

Table Calculation Types

Customize Table Calculations