Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

Calculated Field in Tableau

by suresh

If your data source doesn’t include the fields that you are looking for, then you can create a Calculated Field. In this article, we will show you how to create calculated Field in Tableau with an example.

How to Create Calculated Field in Tableau

You can create a Tableau calculated field in multiple ways, and the first approach is: Please navigate to Analysis Tab and select the Create Calculated Field… option as shown below.

For this Tableau Calculated Field demonstration, we are going to use the data source that we created in our previous article. So, please visit Data Labels in Tableau Reports article to understand the Tableau Data Source.

Calculated Field in Tableau 1

Once you click on the Create Calculated Field… option, a new window will be opened to write the calculation.

Calculated Field in Tableau 2

Second Approach to Create Calculated Field in Tableau

Please click on the Down arrow beside the Sales Amount Measure (change as per your requirement), or right-click on it will open the context menu. From the list of available options, please select the Create option and then select the Calculated Field… option as shown below.

Calculated Field in Tableau 3

Once you click on the Calculated Field… option, a new window will be opened to write the calculation.

Calculated Field in Tableau 4

If you know the formula, you can write directly on that Measure or any other Measure. If you don’t know the function syntax, then click on the side arrow. It will list out all the functions available in Tableau.

Calculated Field in Tableau 5

If you know the function name, use the search box to search for the item. And, if you don’t know then click the down arrow and select the function type

Calculated Field in Tableau 6

In this Tableau Calculated Field example, we will calculate the Running Total so, we are using the RUNNING_SUM function. Here, you can see the example to understand the syntax of a function.

Calculated Field in Tableau 7

Double click on it will automatically add the function to the calculated region. From the below screenshot you can observe that we changed the Calculated filed name to Sales Running Sum

Calculated Field in Tableau 8

Now you can see our newly created calculated field under Tableau measures

Calculated Field in Tableau 9

We created one table report to show our newly created calculated field result. As you can see, the last column is displaying the Running Total.

Calculated Field in Tableau 10

Edit Calculated Field in Tableau

To change the existing table calculation, click on the down arrow beside the table calculation, and select the Edit.. option.

Calculated Field in Tableau 11

Once you on click the Edit.. option, a calculated field window will be opened to edit the existing calculation or function

Calculated Field in Tableau 12

Let us change the function name from RUNNING_SUM to RUNNING_AVG or write down your custom function and click OK

Calculated Field in Tableau 13

Now you can see that the last column in our report is displaying the Running Average

Calculated Field in Tableau 14

Placed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy