Different ways to create calculated fields
There are different ways to create calculated fields in Tableau, as follows:
- From the drop-down arrow beside the Dimensions section in the side bar:
- From the field you want to use in the calculated field:
- From the Analysis menu:
- From the Rows or Columns shelf by double-clicking on an empty space. This is called ad hoc calculation:
- From the Marks card by double-clicking on an empty space. This is also called an ad hoc calculated field:
If you create an adhoc calculation, this piece of information can only be used within the worksheet you created it in. This is not viewable in other worksheets in the same workbook. If you need to persist this field, you can simply drag the pill that contains the ad hoc calculation to anywhere in the side bar. You can rename this field once you see it in the side bar. Once the field is saved, you can use this anywhere in the workbook, just like any other calculated fields. This is shown in the following screenshot:
