Related Item Calculation Fields are here!
Our latest release enhances how calculations can be created within Jama. Users are now able to set up a calculated field that will pull in pick list or integer values from fields on related items (limited to one item type). For example, if you’re practicing Agile and want to roll up estimates to the epic level by adding all points from related downstream stories or if you’re tracking customers/opportunities to product functionality requests, you’ll now have the ability to roll up potential business value to the requests. We’ve also heard some great opportunity where this new functionality can be helpful with risk mitigation and analysis.
We can’t wait to hear of all the different ways you’re planning to use calculations within Jama.
Setting up a calculation that looks at related items is really simple. It’s very similar to setting up a regular calculation.
We’ve added Calculation Source as an option. Here, you’ll select Related Item(s) if you want to look to another item type or This Item to continue with the single item calculation. After selecting Related Items, you’ll then need to select which item type you would like to look to for values. Currently, we limit calculations to use only one related item type.
Let’s walk through setting up this calculated field on our “Epic” Item Type and looking to related “Story” Item Types. Navigate to Admin > Item Types > Epic > Config > Add Field.
Once you’ve selected which Item Type to look to as your Calculation Source, you will select which Relationship Direction want to consider: Upstream, Downstream or all relationships.
Just like setting up single item calculations, now select which fields you want to use in the calculation. (Note that for WSJF, you’ll have options for the numerator and denominator). In this case, only values from the Story Points field of our related Story Item Type. The field options will be limited to integer or pick list field types.
Finish the setup by selecting the number of decimals (1-4) you want to show and whether you require all fields to include a value prior to calculating.
You will notice that we’ve made a few more fields available to be used in a calculation, whether single or related item. You can now select # of Upstream or Downstream Relationships, # of Comments, or # of Connected Users. This is a great way to understand a potential “relevance score”—showing just how connected a requirement or item in Jama really is. In the setup below, let’s roll up an average of those fields for all stories related to epics.
Once you’ve set up your calculated fields, you can now view them in your list or single item views. These fields can also be added to reviews and used within filters. Showing a mixed item view, you can see that there are epics with two related item calculations (Story Points and Relevance) which are pulling from one or several fields on related items.