| Anchor | ||||
|---|---|---|---|---|
|
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.
| Table of Contents |
|---|
To add a calculated field to a report, click the + icon in the bottom right of the left hand panel, under the folders.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
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.
| Info | ||
|---|---|---|
| ||
Calendar Days BetweenUse 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. |
| Info | ||
|---|---|---|
| ||
Working Days BetweenUse 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.
| Info | ||
|---|---|---|
| ||
Count of Candidate Group e.g. Gender, DiversityCOUNTDISTINCT ( CASE WHEN Gender = 'Female' THEN ApplicationID END ) |
Complex Custom Formulas vs. Sub
-queriesQueries
Subquery (for complex calcs) vs calculated fields (simple)