Versions Compared

Key

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

This article helps in building an expression for calculating the percentage of an issue's status/statuses and use that in a report to get the percentage for stories in an epic.

...

To get the percentage of the statuses, create two calculated fields as shown below:

  1. Navigate to Jira Menu → AIO Reports → My Area → My Calculated Fields.
  2. Click Create New Field to create a new calculated field.
    Image Modified
  3. From the right-hand side, search for the function IF ELSE and drag the function to build the expression:
    Image Modified

  4. Also, drag the function EQUALS and place it within the condition:
    Image Modified

  5. Now drag the Current Status field to value1.
  6. For value2: Click "Enter a constant value" and input the Statuses as values:
    Image Modified
  7. For the rest of the value1 and value2 fields: Fill up with values as value1 = 1 and value2 = 0 and name the calculated field as shown below:
    Image Modified

  8. Now, create another calculated field for calculating the % of the Accepted. Build the expression as shown below:
    Image Modified

  9. Create a report of type Matrix and place the Epic Name, Issue Key on the Row fields(Dimensions), Current Status on Column fields(Dimensions) & Accepted%Accepted field on Data fields(Measures):
    Image Modified


Info

In this example, the calculation for the Total will be carried out as ((3/8)*100)/1 = 37.5%.

...