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.
Instructions
To get the percentage of the statuses, create two calculated fields as shown below:
- Navigate to Jira Menu → AIO Reports → My Area → My Calculated Fields.
- Click Create New Field to create a new calculated field.
.png?version=1&modificationDate=1627558613879&cacheVersion=1&api=v2&width=1103&height=150)
- From the right-hand side, search for the function IF ELSE and drag the function to build the expression:
- Also, drag the function EQUALS and place it within the condition:
- Now drag the Current Status field to value1.
- For value2: Click "Enter a constant value" and input the Statuses as values:
- 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:
- Now, create another calculated field for calculating the % of the Accepted. Build the expression as shown below:
- 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):
In this example, the calculation for the Total will be carried out as ((3/8)*100)/1 = 37.5%.