Versions Compared

Version Old Version 12 New Version 13
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 (For calculations based on values of project fields ) the expression with the mathematical formula

    Note

    Build mathematical expressions using:

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


    Time fields calculations

    Time fields return their values in seconds, and they consider Jira time tracking configuration. Learn more.
    E.g.: time tracking = 5d/week - 8h/d -> 2d = 16h = 57600sec


    How to insert Projectrak fields
    Type field_ followed by the field ID: field_44. See IDs on field manager

    Use cases

    Use caseExample
    Remaining time = Estimated time - Total timespentfield_ID - field_ID
    % spent = ( Total spent * 100 ) / Budget( field_ID * 100 ) / field_ID
    % progress = Resolved * 100 / ( Resolved + Unresolved )field_ID * 100 / ( field_ID + field_ID )



  • 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. 

...