Versions Compared

Version Old Version 14 New Version 15
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.

...

  • Name
  • Description
  • Operation
  • Jira Field (For Sum, Count and Average) the Jira field with which the calculation is to be made

  • Build de expresion the expression (For calculations based on values of project fields ) the expression with the mathematical formula

  • Filter issues with a JQL (For Sum, Count and Average)
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. 


Build the expression detailed

Build mathematical expressions using:

  • Math symbols such as + - * / ( )
  • Numbers.
  • Projectrak number, duration or formula field types.
    • Time fields calculations

Type field_ followed by the field ID: field_44.

Operations and examples

OperationExample
Sumfield_1 + field_2
Subtractfield_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

...

How to insert Projectrak fields
Type field_ followed by the field ID: field_44.

Use cases

...

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.