Extract data from a burndown chart

[syee]

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

[Bill Sheboy]

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]

Hi @Bill Sheboy !

Thank you for your help.

Regards,

SY

[Brant Schroeder]

@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]

@Brant Schroeder thank you very much!