record count of stories by status by sprint

[dbrum]

Need to create a filter and then a chart that shows:

# of tasks/stories etc by Sprint

Ordered by Status to get a record count

example:

New: 5

In Progress: 10

Ready for UAT: 4

etc

How would the JQL for a simple query like this look? 

[Coley Anderson]

Agree with the above!

Depending on how many projects you have in your instance, what your settings are - the JQL query could be similar to

issuetype in (Task, Story) AND Sprint is not EMPTY 

and if you use the Two-Dimensional Gadget the output would look similar to

[Jonathan Mao]

This is great. How can do this for a date range?

e.g., show me the number of issues on a certain date range.

Note: I'm interested all the stories on the board in that time period. Not just those created or updated.

Thanks in advance from a JQL n00b :)

[Derek Fields _RightStar_]

This seems to me to be a simple Two-Dimensional Dashboard gadget. You would create a filter that lists all of the issues that you want to include. Then set the Y-Axis to be the Sprint and the X-Axis to be the Status

[dbrum]

thanks - that was easy.

Is there any way to chart this and not just in a table view?

[Coley Anderson]

I think the Two Dimensional Filter is the best way, but you could always play with the charts.

If you have your filter built, you can use that as your saved filter. 

Example: Pie Chart - Statistic type set to Status

Decide if you want to auto refresh or not