Jira Kanban Board - Extracting a report of the stories and story points for the month

[Pragasen Govender]

Hi What is the  simplest way to  run a JQL query to extract the months  stories done /in progress /in testing with the story points  and export to excel 

[Dick]

Hi Pragasen,
My thoughts on on your query were mixed:

• It appears as though you are using the Kanban principle
• However, you might be unaware that Kanban is about having as little as possible active issues on the board. This would mean that the number of stories with status done exceeds the stories with other statuses by far
• Kanban uses releases over an arbitrary period of time, a month is fine
• Releases in Jira gather the stories done in a convenient manner and makes it visible to the user if the flow of issues is hampered in any way
• This way the throughput of the team can be assessed and discussed
• Clicking a release from the release list in Jira gives you the opportunity to directly show:
  • A comprehensive list of issues in the version with priority, type, key, summary, assignee and status 
• next to: 
  • The number of issues in the version
  • The number of issues done
  • The number of issues in progress
  • The number of issues to do
• Furthermore, by clicking the "View in issue Navigator" link, you end up with a pre-built search finding exactly those issues mentioned above, which you can export to excel. 

It appears to me that you should explore Jira a bit more, or perhaps hire a flow master who undoubtedly could guide your team to further greatness. 

Sincerely,

Dick