Page Comparison

This article helps in building an expression for calculating the percentage of an issue's status/statuses and use using 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. 
   Note: Access to the app is controlled by the Access Permissions option, which is accessible only to a Jira administrator. If the group they belong to is not selected, users will not see the AIO Reports menu item. In this case, the Jira administrator can perform the below steps:
   
2. Click Create New Field to create a new calculated field.
   Image RemovedImage Added
   
3. From the right-hand side, search for the function IF ELSE and drag the function to build the expression:
   Image RemovedImage Added
   
   
4. Also, drag the function EQUALS and place it within the condition:
   Image RemovedImage Added
   
   
5. Now drag the Current Status field to value1.
   
6. For value2: Click "Enter a constant value" and input the Statuses as values:
   Image RemovedImage Added
   
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 RemovedImage Added
   
   
8. Now, create another calculated field for calculating the % of the Accepted. Build the expression as shown below:
   Image RemovedImage Added
   
   
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 Removed
   

...

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