Forum Discussion

SJain15's avatar
SJain15
New Contributor
2 months ago

Pie chart to display test coverage and no coverage

Hello,
I want to create a Jira pie (donut) chart report, to display test coverage and no coverage (just two groups). Pls can someone suggest if it is possible using JQL filter criteria and how.
GroupBy clause is not available in JQL. 

I'm using following filter to display the test coverage report at the moment. However, I'm unable to display both coverage and no coverage in a single chart.

project in ("ABC", "XYZ") and issuetype in (Defect, Story) AND issue in hasTestCoverage()  

Thanks.

4 Replies

Sort By
  • MisterB's avatar
    MisterB
    Icon for Champion Level 3 rankChampion Level 3
    2 months ago

    I've not tried this but can see the difficulty trying to make it work.  Possible solutions:

    1. Return all issues, then use the gadget to split issues by Test Coverage, or if that's not available, another field like labels or a custom field
    2. I'm thinking you could create two separate filters: one for coverage, one with no coverage, and then have a parent filter that returns the results of both child filters
    3. Use Jira Automation to assign a custom tag to define coverage/non-coverage and use that field in your JQL
    • EcoRich's avatar
      EcoRich
      New Contributor
      2 months ago

      Hi, 

      My jira Cloud instance does not have hasTestCoverage() and the other listed functions.  Are they only available in the Server versions like the Zephyr Confluence plugin.
      Really looking for reports about the tests that can be shown in dashboards or confluence pages, but seems most of the reports are execution result based.  E.g. Test coverage, manual vs automated tests, burndown chart based on a field (automated yet?), bug vs test density of feature, Test Review Package, Test Package for external Auditors, etc.

      Can we create our own reports like other TMS solutions, if you know php/html :)

      Thanks

       

  • MisterB's avatar
    MisterB
    Icon for Champion Level 3 rankChampion Level 3
    2 months ago

    Hi,

    It's a frustration that we can't use those JQL functions in the Cloud instance, and also that we do not have report capability on the Test Library and Issue level - I have tried for years to get this addressed with no luck.

    To answer your question, it is possible to create your own reports - I often have to.  There are two options:

    1. Create a report and export the data to CSV.  Note: all reports export the same data, and not all fields that we see in the UI are exported
    2. Use the REST API

     

  • EcoRich's avatar
    EcoRich
    New Contributor
    2 months ago

    Hi,

    Thanks.  On the TestRail Server version I could access the folder containing the report code,  take a copy of an existing report and save it back under a new filename with some tweaks.  It was the Official method for adding custom reports.
    I am now at a new company trying to incorporate Scale, might look at your suggestion of using API to take data into Grafana or Tableau  ($$$)