Calculated Field basics

A Calculated Field is a new field in your data source. It can have any data type. You can build a calculated Measure or Dimension. To differentiate a field from the Calculated Field, each data type icon has a small equals symbol in front of it, as you can see in the following screenshot:

Let's start by learning how to create a Calculated Field.

Creating a Calculated Field

To create a new Calculated Field, go through the following steps:

1. Click on the small arrow next to Dimensions in the Data pane, highlighted in the following screenshot: 

It's also possible to right-click on a field and go to Create to start a new Calculated Field based on this field. You can edit a Calculated Field when you right-click on it.

2. When you create a new Calculated Field, a new window opens where you have to write a formula. The formula can be based on other fields, calculated or not, and use functions.
3. On the right, when you click on the arrow, you can open the list of functions.
4. When you write...