How to get cycle summary summarized for each test step?

In my setup, features to be included in a test cycle have associated test steps with them. Status of each test step executed is recorded as 'Blocked', 'Pass', 'Fail', 'WIP' (using Zephyr). I get execution details that show each test step and its result based on cycle, but to get this summary I have to export this data in an Excel and create a table (Pivot table) helps. 

Is it possible to get such a report directly from JIRA? The fields I would like to have are Test Summary (basically the feature getting tested) and count of status of each step for Test Summary as columns. 

1 answer

0 votes

If you are generally OK with Excel as tool, but want to save the repetitive part of re-creating the pivot table every time, then you could get the final result with one click using the Better Excel Plugin.

The idea is that this add-on generates Excel reports from templates, therefore you have to setup the pivot table in the templace only once, and it will be filled with the most current data every data.

See some Zephyr report samples


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted 6 hours ago in Agile

What is Scrum? A good, bad, and ugly answer.

In a world of dark-scrum, faux-scrum, and scrum-butt, the question still remains: What is scrum and how do you do it “right?” That’s the question we set out to answer. I'm Max, I've been teaching c...

44 views 0 1
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you