What is the dashboard gadget name where I can get sprint details in tabular column?(Jira cloud)

[Priyanka R]

I want to  display the sprint report in tabular column in Dashboard level. For this I want to add a gadget showing the results like how many issues opened and closed in sprint 1 and sprint 2 .can you please suggest a gadget where my requirement meets? It should not be in graphical view .it should be like tabular format! 

Thanks in advance! 

[Vishwas · Accepted solution]

Hey @Priyanka R 

From the requirement it sounds like you can make use of "Two Dimensional Filter Statistics" gadget with Sprint as Y-axis and Status as X-axis. SO you will get a tabular view sprints for the filter.

Let me know if this works out.

Regards,

Vishwas

[Priyanka R]

@Vishwas 

Thanks for your reply!

Can i export it in Excel file?

[Vishwas]

@Priyanka R 

you mean the gadget export?

[Priyanka R]

@Vishwas 

Yes!

Thanks!

Priyanka

[Vishwas]

Nope, we dont have export to pdf. Just a view like this on dashboard

[Priyanka R]

@Vishwas 

Thanks for your reply!

1. Is there other option to export in Excel ? 

2. In sprint level can we display Zephyr scale cloud test cases results ? 

Thanks! 

[Vishwas]

Hey @Priyanka R 

1. To export the only option is to write JQL filter in "Issue Navigator" and from there we can export to excel.csv. But at dashboard level out of the box it is not possible.

2. Not sure on the Zephyr thing, but I'm pretty sure there will zephyr specific gadgets. You can check this in gadget search by giving "Zephyr Scale" then all the related gadgets will be listed.

[Priyanka R]

@Vishwas 

What is the JQL filter to display sprint open and close status ?

[Vishwas]

Ahh, i got the point now you are asking the status of sprint like sprint is open or closed ?

Or the status of issues as open/closed against that sprint ?

[Priyanka R]

@Vishwas 

Status of issues which are in open status in sprint 1 and sprint 2 can we get the results basing on JQL query?

My requirement is individually sprint1 issues which are in open status and sprint 2 issues in open status . Please suggest JQL query for this!

Thanks!

[Vishwas]

okay

sample JQL: Project = ABC and status in (Open,Done) 

The above JQL will display only issues which are in 2 status that is Open and Done against Each sprint

[Priyanka R]

@Vishwas 

Thanks for your reply !

For only specific sprint1 status( open,closed)  I need then what is the JQL query? 

[Vishwas]

JQL would be : Project = ABC and status in (Open,Closed) and Sprint = <sprint_id>

For sprint id you can start typing in JQL it will get auto filled like this.

[Priyanka R]

@Vishwas 

Thank you so much for your reply! 

one last question ! In addition to this I want to add sprint name column so that when i export into excel it is easy to identify it belongs to particular sprint (open , close) status !

Please suggest !

Thanks !

Priyank

[Vishwas]

You need to add "Sprint" Field in the columns option before you export.

Like this

[Priyanka R]

@Vishwas 

@Thank you for your reply!

[Jan Denny]

Is there a way to address the problem where the same issue will be counted multiple times in this widget if it has been in multiple sprints? Here are my dimensions using this widget. The widget totals are wrong because the same issue is counted in past sprints as well as current and future sprints, even though my filter is selecting only issues in current and future sprints.