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

Questions & Answers
, , , ,
1

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

image
image712Ă—366 56.6 KB

Created Analysis
image

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

image
image1558Ă—649 52.4 KB

Kindly help us on this as Priority

Thanks in Advance

Regards,
Revathy Madhavan

2

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

3

Hi @zane.baranovska ,

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

Regards,
Revathy Madhavan

1 Like
4

Hi Team,

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

Help us by providing the exact report based on screenshots provided.

Screenshot 1:

Required Analysis

image
image862Ă—439 99.3 KB

Kindly help us on this as Priority

Thanks in Advance

Regards,
Revathy Madhavan

5

Screenshot 2:

Created Analysis

image
image756Ă—142 11.7 KB

Regards,
Revathy.M