Calculated Fields allow you to manipulate or change how results appear in your report, over and above the Group Data or Advanced Function options that are available in a field's format options.
You can use a Pre-Defined formula or build your own, depending on your requirements.
To add a calculated field to a report, click the + icon in the bottom right of the left hand panel, under the folders.
Pre-Defined Formula
A number of functions are built in that you can use with date, time or metric fields. Choose Pre-Defined for the Formula Type to explore what's available.
For any selection, you'll need to:
1) Define the field type as Dimension or Metric
2) Define the value(s) (fields in the view) that the function needs to refer to.
3) Give your field a name (if you didn't at the start) and save.
Pre-Defined Formula Examples
Calendar Days Between
Working Days Between
Custom Formula
To create your own formula, choose Simple as the Formula Type.
You'll now see a formula builder screen like this.
Custom Formula Examples
Count of Candidate Group e.g. Gender, Diversity
COUNTDISTINCT ( CASE WHEN Gender = 'Female' THEN ApplicationID END )
