Need a JQL Query for creating a dashboard in form of percentage

Pooja_Shetty

Filter is

List of All automable Testcases

List of already automated testcases - Yes

List of already automated testcases - NO

I need to create a dashboard to display the percentage completion of the automation issues till date

Can you help me with the JQL query and the exact gadget to be used for this one

 

Nic Brough -Adaptavist-

Two parts to this:

• We can't write JQL without knowing what it is supposed to find.  How are you telling your Jira issues about the test cases?
• JQL finds issues.  It has nothing to say about the outputs.  You'll need to find a gadget that can read the results of a JQL filter and do the percentage calculations for you.

Off the shelf, I can't think of a way to do this, the closest I can get is simple issue statistics gadget on the dashboard, grouped by the value of a custom field that contains your yes or no answer for each issue.