NEW JSU Calculated Fields functionality

We are excited to introduce the new powerful functionality of JSU Calculated Fields now deployed into your Jira Cloud instance. This is to help you easily automate your Jira workflows when performing mathematical, aggregate, and relation functions in issue fields. 

If in the past you need to manually open your issues to extract numerical values and perform your computations on a different platform, with JSU Calculated Fields, you may now do all the work in Jira. 

Here’s to better illustrate this new functionality:

Example use case

Time to plan your roadmap!

Identify your priorities by finding out which items on your backlog would achieve the most business value in the quickest time.

Follow the configuration below. 

How to configure this workflow

Step 1

Calculate the “Total Story Points on the Epic.” Go to your apps and select the Calculated Fields from the left-hand navigation. Click to create your first calculated field.

Start by naming your field “Total story points” and move to the formula to configure your calculated field.

We want to calculate the sum of the story points in the stories of our epic. Select the sum function from the dropdown and then select the issuesInEpic function too.

When the issuesInEpic function is combined with an aggregate function like the sum, it will retrieve the values of the selected field from all issues in the epic.

Next, from the fields drop-down menu, select the story points field to add it to the formula.

Select the project you want your calculated field to appear and click create.

Step 2

Calculate the “total Business value” of our epic.

Create a new calculated field and give it the name Total Business value of Epic. Move to the formula and start by adding the sum function from the functions drop-down. Then, add the issuesInEpic function for the field “Business value” to retrieve the values of the Business value field from all issues in the epic.

Select the project you want the calculated field to appear and click create.

Step 3

Lastly, divide the “total business value of the epic” with the “total story points of the epic” to determine the fruitiness of each issue.

Create a new calculated field and name it “Fruitiness”.

You have the option to round up the Fruitiness to the highest whole number, by adding the function ceiling from the functions drop-down first.

Then, from the Fields drop-down, select the “Total Business value” field, click on the division operator and then select the “Total story points” field as the divisor.

Select your project and create the calculated field.

Step 4

Go to your backlog and open one of your epics to see at the right-hand corner all of the calculated fields we’ve created.

Now that your calculations are done. Set up a dashboard with a filter that sorts all the epics with each Fruitiness score arranged from high to low.

That’s how you can prioritize your projects!

How to video

This feature is extremely useful for project managers making business decisions. Being able to attach a numerical value in your issues and show calculations inside each epic gives your work some sense of order. This is just one of the many use cases for this new feature.

Watch this how-to video and try it out to discover for yourself the power of JSU Calculated Fields. 

This was only a bit of JSU in action. Subscribe to our YouTube channel and Access more JSU use cases.

Need more Information or help? Get in touch!

The new JSU Calculated Fields feature is available on Jira Cloud. Get it from the Atlassian Marketplace.


For some more examples and configuration screenshots, go to…