JQL Query for Summing stories by status and assignee

Jonathan Garner

I am attempting to show the progress of issues of a time frame by status and by assignee. I feel like this should be done by using the JIRA Javascript chart gadget for dashboards. I use as my JQL script.

 

project ="SPS" AND assignee was Niketan AND status was in ('In Dev')

Y-axis: issue count (I only want the raw number of stories over the time span)

X-axis: custom defined timeframe

Time Series Field: None(sum of existing issues)

Unfortunately i keep getting a return of a horizontal zero line, I have double checked to ensure that this user has had issues in that status over the time frame. 

 

Thoughts. 

 

Mehmet A _Bloompeak_

Hi @Jonathan Garner

Welcome to Atlassian Community!

If you prefer to use a marketplace app, you can try Reports - Charts and Graphs for Jira Dashboard app developed by our team to create various reports, charts and graphs for your Jira projects.

• You can create custom, flexible and colorful bar charts and table views for any data you want/need. As data source, you can choose Projects or Saved Filters or Advanced (JQL).

• You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.
• You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.
• You can group your data on any field(Sprint, Status, Assignee, Component, Project etc.) you want.
• You can choose various date ranges like All Time, Last Year, Last 3 Months, Last 6 Months etc.
• You can modify existing Segments or add new segments.
• You can order the results by drag and drop.

Here is a sample report that shows sum of story points by status and assignee.

 

Below you can see an article about creating custom reports, charts and graphs in Jira with our app.

How to Create Custom and Flexible Reports, Charts and Graphs in Jira

Here is our live demo dashboard where you can see and modify sample reports and play with them.

Hope it helps.