easybi - count of linked issues based on link type

[Gundlupet Sreenidhi]

I would like to generate a report which has a table. 

Each row identifies an issue. 

I want one of the columns to indicate the count of linked test cases (i.e: link type is "tested by" and linked issue type is "test") and another column to indicate the status of the test case execution (pass / fail). 

Can someone please help me generate this report using EasyBI?

FYI: we use XRay plugin for Test Management.

Thanks

[Zane eazyBI Support · Accepted solution]

Hello,

To analyze data from Xray, you may enable data import from Xray into eazyBI (https://docs.eazybi.com/display/EAZYBIJIRA/Xray+Test+Management).
After data import, new Xray specific dimensions and measures will be available for your reports.


Then you may create a report which represents issues and their testing coverage.

1) Select Xray Requirement dimension as rows. This dimension will represent Issues which are linked to tests.

2) Select measure Xray Tests created as columns to represent how many tests are linked to each issue. 

3) Select measure Xray Tests execution summary as columns to represent execution statuses of linked tests.

A report may look like this:




You may click on Xray Tests created value in a cell and select Drill through Test to get a list of linked tests.

Best,
Zane Baranovska / support@eazybi.com