How do I create Test Coverage %

Questions & Answers
1

Formulae for Test Coverage %=(( total test cases - total test cases whose XRAY execution status is only deferred and descoped )*100)/total test cases

I tried to create it via JIRA dashboard gadget, but i am not able to find any option to create such report via gadgets or smart/rich filters.

Report should include the list of components and coverage %

For example-

Component Total Test Cases Total test cases (only contains deferred and descoped) Coverage %
XYZ 10 7 30%

Coverage%=((10-7)*100)/10=30%

Could you please help us out here… here we are executing our test cases via XRAY.

I tried multiple gadgets and rich filters.

2

Hi @niti.saxena

Welcome to the eazyBI Community!
You may try building the following report, where for the measure you choose Xeay Tests executed, and you drill into the Xray Test run Status (here is the documentation about how you can drill into another dimension from the Measure name - Interact with report

image
image1758×742 61.3 KB

Then you could try defining a new calculated measure (Calculated measures) with the formula below (choosing the Percentage formatting before saving the calculated measure- Calculated measures ). Make sure you use autofill functionality for the test run statuses Deferred and Descoped to be sure that formula picks up correct statuses.

Aggregate(
  {[Xray Test Run Status].[Deferred],
  [Xray Test Run Status].[Descoped]},
  [Measures].[Xray Tests executed]
)
/
  ([Measures].[Xray Tests executed],
  [Xray Test Run Status].CurrentHierarchy.DefaultMember)

Best wishes,

Elita from support@eazybi.com