nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

percentage calculation in Jira

Akeem Ibrahim

Hello Gurus,

I have this issue to configure on JIRA with Automation rule in the custom fields, to give result anytime issue created to get the percentage of issue ranked. They are as follow as example:

1. Dining Set = 40%. 2. Furniture set = 40%. 3. Kitchen set =20% Total =100%.

a. Table =40% C.table =38% Oven =35%

b. Chair =32% Sofa =40% D.washer = 35%

c. table cloth =28% stool =22% Microwave = 30%

with 1, 2, 3, being an issue, and their dropdown are the issue class underneath. I want the condition in automation to have the following result:

Result Priority:

Highest = >70%

High = 50% -69%

Medium =30% - 49%

low = 20% - 39%.

I am currently an app on JIRA (JMWE), but i am still finding it difficult to get the result.

Accepted answers

All comments

Bill Sheboy

Hi @Akeem Ibrahim

Using automation rules often requires learning and experimentation. I recommend trying to build your rule, and if you run into challenges post your rule and audit log so the community can help.

To get you started, I believe you can do what you ask with the new Lookup Tables feature, and/or conditions and math expressions. Please look here for more information:

Kind regards,
Bill

Akeem Ibrahim

Hello Bill,

Many thanks for helping out. I am still facing errors in the "Automation", i have attached some result pictures here. What i tried to do this time was to just take 2 issues and see if i could automate the weighted average. Web capture_11-4-2023_105828_tunde847.atlassian.net.jpeg Web capture_11-4-2023_105811_tunde847.atlassian.net.jpeg Web capture_11-4-2023_105655_tunde847.atlassian.net.jpeg Web capture_11-4-2023_10555_tunde847.atlassian.net.jpeg Web capture_11-4-2023_105314_tunde847.atlassian.net.jpeg

This are the errors, i am facing with the automation. Kindly look into this if there could be any correction.

Bill Sheboy

First thing: when posting images of your automation rules, please post the image of the entire rule. This can be done using a screen capture tool, such as one that can scroll the browser tab. When you post multiple images for pieces of a rule it can be difficult to see the overall context.

Next, also post the image of the entire audit log details for the rule execution. That will show at what point the rule had problems.

From what I can see of your rule...

In the first image showing Edit Issue Fields, the section for "Additional fields" may only contain JSON. What you show is not well-formed JSON. And, JSON usually only needed when your field is not listed in the drop-down list for edit. To learn how to write well-formed JSON for fields, please look here: https://support.atlassian.com/cloud-automation/docs/advanced-field-editing-using-json/

Next, when referencing a field in a rule, you may use {{issue.fieldName}} rather than {{issue.fields.fieldName}}

Finally, in the Advanced Compare Condition and in the Create Variable action, you have a smart value expression which does not make sense to me. That are you trying to do with the expression below?

{{[ | percent(0.6012 )]}}

Akeem Ibrahim

Hello Bill, Thanks for you support. I followed the steps you highlighted from previous post. I created the automation in the following:

1. Issue to triggers rule:

2. I created variables as the "actions"

3. I created "Look up table" for all the variables for their percentage value.

4. Then I created edit field in "Action" to put the calculation. here is the weighted average calculation in smart value: {"Business Worth"} =| percent(0.4012) * {"Operational cost"} =| percent(0.6512) * {"Cosmetic Change"} =| percent(0.3512) + {"Risk and Regulatory Compliance"} =| percent(0.4012) * {"Internal Control"} =| percent(0.6012) * {"Customer Facing"} =| percent(0.4012) + {"Capability and continuity"} =| percent(0.2012) * {"Yes to Strategic Planning"} = | percent(0.7512) * {"more than twelve months"} =| percent(0.2501)/100

5. The edit field to have the percentage is a numerical custom field, and i still get the error.

Here are the pictures Web capture_12-4-2023_13033_tunde847.atlassian.net.jpeg

This was the error i received above.

Web capture_12-4-2023_12524_tunde847.atlassian.net.jpeg Web capture_12-4-2023_125344_tunde847.atlassian.net.jpeg Web capture_12-4-2023_125437_tunde847.atlassian.net.jpeg Web capture_12-4-2023_125627_tunde847.atlassian.net.jpeg

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud