First Pass Rate (Tracking bugs) for Jira Dashboard

[Simon Levison]

Hello Atlassian Community,

I am working with a Scrum board that has Epics/Stories from multiple projects. QA tracks failed tests via bugs (sub-tasks) within stories. Our DoD requires a story to pass QA and UAT per the usual. 

We are looking to track the first pass rate (FPR) of stories over time by calculating the percentage of stories that were completed without bugs. Ideally, we would want this to show by sprint or otherwise weekly and preferably be shown in a graph. As an enhancement, we would also want to capture only P1 and P2 bugs for the calculation.

I have not bee able to find a native way within Jira to show first pass rate.  

• There doesn't seem to be a dashboard gadget that allows us to assess the results from one filter against another (eg. filter of stories versus filter of stories with bugs)
• There isn't a way to calculate percentages 
• Reporting feature doesn't appear to include anything for tracking FPR
• Using queries and displaying results per sprint is also misleading as there is no way to avoid duplicate counting of any carryover work. 

The only solution I found was to query for all stories that have a bug sub-task and display the results.

Here is a query example I use showing stories with bugs in current sprint:

labels = Pod1 AND type = story AND sprint in openSprints() AND issueFunction in linkedIssuesOfAll("issuetype = bug AND priority >= 2")

Questions:

Is there a report I can generate in Jira to see first pass rate?

Is there a way I can calculate the percentage of one query to another and display on a dashboard?

Available systems:

JIRA v7.8.0

Confluence 6.2.3