Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira Structure Calculate Defect Ratio from result of two folder using JQL in them

Mikhail
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 31, 2024

Dear Experts,

I am using Jira Stricture to calculate defect ratio in production.

I have two folder and filters and JQL to calculate quantity in Production environment and defect before production.

 

How to devided by the result of two folder or create the formula ( 1 - Defects in Prod/Defects before Prod)?

Plese see the screenshot 

 

Or may be you cold suggest alternative desicin for this task.

 

 

Folder name                                  quantity defect                                        Defect ratio

                                                                                                                     Defect ratio 1- 2/8

+Defect in prod                                         2

+Defectbefore prod                                    structure.JPG 6

1 answer

Suggest an answer

Log in or Sign up to answer
0 votes
Stepan Kholodov _Tempo_
Community Champion
July 31, 2024

Hello!

You can try a formula like this, referencing both folders by their names:

if search("Defects in Prod",summary): quantitydefect/parent{sum{quantitydefect}} else
if search("Defects before Prod",summary): quantitydefect/parent{sum{quantitydefect}}

You can also try a different approach with referencing folders as non-issuetypes that have a non-issue type parent(which is the root of the structure - the structure's name at the top - in this case):

if !issuetype and parent{!issuetype}: quantitydefect/parent{sum{quantitydefect}}

but this one only works properly if there are no folders/groups under the two folders in question, and they only have issues as sub-items.

I hope this helps. If you need further assistance with the formula or if you have other questions about Structure, please reach out to us directly at our support portal at: https://tempo-io.atlassian.net/servicedesk/customer/portal/6/group/1051

Best regards,
Stepan
Tempo (the Structure app vendor)

TAGS
AUG Leaders

Atlassian Community Events