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 vote

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 Join to answer
Community showcase
Jason Wong
Published 12 hours ago in Agility Beta

Welcome to agility

Every team in the world is unique, and so   Atlassian believes   that each and every team's best way of working  needs to  be molded to their unique circumstances  – ...

231 views 5 14
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot