Versions Compared

Version Old Version 25 New Version 26
Changes made by

Leo Díaz Murillo

Leo Díaz Murillo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this section, you will be able to learn about Projectrak field types. How to configure and set them up and what you can do with each one.

...

Formula field allows you to perform the following calculations:

Image Added

  • Sum values of an issue field: sum up values of a specific issue field by project.
  • Count issues: get an issue count per project.
  • Average values of an issue field: generate the average of issue field at a project level.
  • Calculations based on values of project fields: execute calculations based on project fields.

...

Info
titlePlease note
  • Values will be calculated according to the user's permissions for the application.
  • JQL is used for more accurate calculations, this search will be performed by a service, not a specific user. So please, keep in mind that Date and user functions can return inconsistent results, E.g. currentUser(), lastLogin().
  • The synchronization process for the formula fields takes around 3 hours to be completed. So if at first, you don't see any results, please wait until the whole process is done. 

...

Examples:

OperationExample
Sumfield_1 + field_2
Substractionfield_3 - field_2
Multiplicationfield_1 * field_3
Divisionfield_3 / field_1
Mix(field_1 * field_2) / 100


Note

Time fields return their values in seconds. Be careful because they will consider Jira time tracking configuration and it may cause unexpected results.

E.g.: time tracking = 5d/week - 8h/d -> 2d = 16h = 57600sec
For a time tracking of 5 days per week and 8 hours per day, a time field with a value of "2d" in the project will have a real value of 16 hours and in the expression will evaluate as 57600 seconds.

...