This article explains the possible methods that can be used in calculating the aggregate results when using the DIVIDE function in a calculated expression.
Instructions
Consider the example as Story points being divided by a number:
- Login to Jira and navigate to AIO Reports → My Area → My Reports.
Please note that access to the app is controlled by the Access Permissions option, which is accessible only to a Jira administrator. Users will not see the AIO Power BI menu item, if the group they belong to, is not selected. In this case, the Jira administrator can perform the below steps. - Click Create New Field to create a new calculated field.
- From the right-hand side, search for the function DIVIDE and drag the function to build the expression.
- Now drag the Story Points field to the value.
- Input 60 as a value.
- Name the calculated field along with a description and validate the field and use it in reports.
This method is called The Ratio of the sum, which is the app's default behavior. For example, if there are 2 issues i.e., issue1 has an SP value of 15 and issue2 has an SP value of 45, then the calculation according to the Ratio of the sum method would be
15/60 + 45/60. The result would be 1. - Also, there is another way of calculating this i.e., Sum of ratios. How does it work? Alright, the calculation will be performed as (15+45/60+60) i.e., wrapping the above expression with MULTIPLY function. The end result would be 0.5.
The usage of the methods depends on case to case. Preferably, the Ratio of the sum would do the trick but in some cases, Sum of ratios works.