Extract data from a burndown chart

syee March 10, 2021

Hello,

Is there a possibility to extract data from a burndown chart? I've been trying to create a filter with all the "scope change" tickets but haven't had success.

Regards,

SY

2 answers

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 10, 2021

Hi @syee  -- Welcome to the Atlassian Community!

You have two questions, with some overlap between them.

 

1) Is there a possibility to extract data from a burndown chart?

No, but you can pull the Sprint Report as JSON for a completed sprint using the REST API, substituting in yourCompanyInstanceURL, yourBoardNumber, and yourSprintNumber

yourCompanyInstanceURL/rest/greenhopper/1.0/rapid/charts/sprintreport?rapidViewId=yourBoardNumber&sprintId=yourSprintNumber

 

2) I've been trying to create a filter with all the "scope change" tickets but haven't had success.

This is not possible with out-of-the-box Jira JQL. If you have one of the marketplace scripting  or reporting addons, several have features to support this.  For example, ScriptRunner.

Without a marketplace add-on, there are a few work-arounds:

  • You could export issues to a spreadsheet, and use formulas on the Sprint column to determine scope change.  This will probably be incomplete information.
  • You could use the REST API and expand the changelog for issues to automate what could be done manually looking at each issue
  • You could use custom fields and automation rules to automatically detect this for future sprints, but not previously closed sprints

 

Best regards,

Bill

syee March 11, 2021

Hi @Bill Sheboy !

Thank you for your help.

Regards,

SY

Like Bill Sheboy likes this
0 votes
Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 10, 2021

@syee - Welcome to the community.  Unfortunately there is no way at this time to export data from burndown charts.  If you have ScriptRunner I believe you can use the following to get the information you are after.

issuefunction in addedAfterSprintStart(board-name, [sprint-name])

issuefunction in removedAfterSprintStart(board-name, [sprint-name])

syee March 11, 2021

@Brant Schroeder thank you very much!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events