Need to create report with linked test cases count & linked issues under the sub-task/epic/story

Hi Team,

We have created an Analysis in Eazybi with Assignee, sub-tasks & hours spent in sub-tasks but we have a blocker on providing the linked test cases count in the existing report.

So please help us on creating a meaure with linked test cases count & linked issues under the sub-task/epic/story.

Please find below the required analysis & Created Analysis

Required Analysis

Created Analysis
image

Application eg from which the highlighted content should be added in the Analysis

Kindly help us on this as Priority

Thanks in Advance

Regards,
Revathy Madhavan

Hi @RevathyMadhavan,

It looks like you are using the Zephyr Scale app (former TM4J app) for test management. eazyBI has integration with this app, and you can import testing data (test plans, test cases, tests cycles, and execution results) in eazyBI.

First, you might want to import data from Zephyr Scale (former TM4J) in eazyBI. More details on how to do this and what new metrics and dimensions will be available: Zephyr Scale Test Management for Jira - eazyBI for Jira.

Issues covered by test cases are represented in dimension “TM4J Requirement”, and the assigned test count is represented in measure “TM4J Test Cases created”. To make this dimension and measure work for your report, you might want to create a new calculated measure in the Measures section.

The calculation would get the Issue key on report rows, look up this issue in the “TM4J Requirement” dimension, and then check how many Test cases are associated. The expression might look like this:

DefaultContext(
  --Zpehyr Scale specific measure showing test case count
  ([Measures].[TM4J Test Cases created],
  --look up issue from report rows in TM4J requirement dimension
  [TM4J Requirement].[Requirement].GetMemberByKey(
    [Issue].CurrentHierarchyMember.key) )
)

Best,
Zane / support@eazybi.com

Hi @zane.baranovska ,

Thank you so much for the update !
It works like a charm

Regards,
Revathy Madhavan

1 Like