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.

In this section

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.

Calendar Days Between

Use this to calculate the calendar days between two dates captured in the system, like job created and job archived, or another date you record against a custom global question on a form.

Working Days Between

Use this to calculate the business days between two dates captured in the system, like job created and job archived, or another date you record against a custom global question on a form.

Custom Formula

To create your own formula, choose Simple as the Formula Type.

You'll now see a formula builder screen like this.

Count of Candidate Group e.g. Gender, Diversity

COUNTDISTINCT ( CASE WHEN Gender = 'Female' THEN ApplicationID END )

Complex Custom Formulas vs. Sub-queries

Subquery (for complex calcs) vs calculated fields (simple)