KNOWLEDGE BASE

Converting a Quick Table Calculation into a Calculated Field


Published: 22 Dec 2016
Last Modified Date: 29 Dec 2016

Question

How to convert the quick table calculation into a calculated field in order to use it more than once in a workbook.

Environment

Tableau Desktop

Answer

Option 1

  1. Create the quick table calculation. For information on how to create a quick table calculation, see Quick Table Calculations in the Desktop Help.
  2. Drag the Quick Table Calculation pill to the Dimensions or Measures pane and rename the calculated field as desired.

Option 2

  1. Create the quick table calculation. For information on how to create a quick table calculation, see Quick Table Calculations in the Desktop Help.
  2. Double-click the Table Calculation in the view and copy the formula. 
  3. Select AnalysisCreate Calculated Field... 
  4. Rename the calculated field as desired and paste the formula. 
  5. Click OK.

To view the above steps in action, see the video below: 

Additional Information

In Tableau Desktop 8.3 and earlier versions

  1. In the view, right-click the measure that's using a quick table calculation (control-click on Mac), and then select Edit Table Calculation.
  2. In the Table Calculation dialog box, click Customize. This opens the Calculated Field dialog box.
  3. In the Calculated Field dialog box, give the calculated field a name, and then click OK. The new calculated field appears as a measure.
Did this article resolve the issue?