Calculated fields are custom fields you can add to your data source. Their values are determined by the custom formula you yourself write. In this recipe, we will create a simple calculated field that contains the difference in value of Civilian Labor Force between each data point and the data point preceding it.
Creating calculated fields
Getting ready
Connect to the Unemployment_rates_1990-2016.csv dataset, and open a blank worksheet.
How to do it...
- Click on the black drop-down arrow in the Data pane, to the right of Dimensions.
- Select Create Calculated Field…...