Tableau Numeric Calculations

In Tableau, numeric calculations are done using a wide range of inbuilt functions available in the formula editor.

Let's see how to apply calculations to the fields. The calculations are simple as subtracting the values of two fields or using an aggregate function to a single field.

Here are the steps to create a calculation field and use numeric functions in it.

How to Create a Calculated Field

  • After connecting to a data source such as Sample-Superstore.
  • Go to Analysis menu.
  • And click on Create Calculated Field as shown in the below image.
Tableau Numeric Calculations

Calculation Editor in Tableau

The above process opens a calculation editor which lists all the functions available in Tableau.

Tableau Numeric Calculations

You can change the dropdown value and only see the related functions to numbers.

Tableau Numeric Calculations

Create a Formula

o visualize the difference between Profit and Discount for different shipping mode of the products, create a formula that subtracts the Discount from the Profit, as shown in the below image, and the name of this field is profit_n_discount.

Tableau Numeric Calculations

Using the Calculated Field

The above-calculated field can be used in the view by dragging it to the Rows shelf as shown in the below screenshot.

It produces a bar chart that shows the difference between profit and discount for different shipping modes.

Tableau Numeric Calculations

Applying the Aggregate Calculations

You also can create a calculated field using an aggregate function.

  • First, create AVG (sales) values for different ship mode.
  • Then, Write the formula in the calculation editor as shown in the below screenshot.
Tableau Numeric Calculations
  • Click OK and dragging the Avg_Sales field to the Rows shelf, then you get the following view.
Tableau Numeric Calculations




Latest Courses