Page Comparison

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:

1. Login to Jira and navigate to AIO Reports → My Area → My Reports → My Area → My Reports. 
   Please note that access
   Note: Access to the app is controlled by the Access Permissions option, which is accessible only to a Jira administrator. Users If the group they belong to is not selected, 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. :
   1. Click Create New Field to create a new calculated field.
   2. From the right-hand side, search for the function
   DIVIDE 
   1. DIVIDE and drag the function to build the expression
   .
   1. :
      
   Image Removed
   1. Image Added
      
      
   2. Now drag the Story Points
    field
   1.  field to the value.
   2. Input 60 as a value.
   3. Name the calculated field along with a description and validate the field and use it in reports
   .
   1. 
      
   Image Removed
   1. Image Added
      
      This method is called
   The Ratio
   1. 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.
      
   2. Also, there is another way of calculating
   this i.e.,
   1. 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.
    
   1. 
      
   Image Removed
   1. Image Added