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

Question

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                                    
6

Stepan Kholodov · Answer

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)