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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.