How can I export the raw data from the JIRA Reports?

[Steve Hooczko]

I want to be able to pull the data from a report, such as Cumulative Flow Diagram, and export it to Excel.

[Nic Brough _Adaptavist_]

The "raw data" for the reports is just "the issues the report looks at", so if you run a search for the issues it is reporting on (often as simple as "project = XYZ" and updated > -30d"), then you'll be able to use the download option on the tools to get a spreadsheet-friendly dump of the raw data.

[Steve Hooczko]

Is there a way to see the JQL or other source that drives the reports in order to create my own gadget with mods?

[Bill Sheboy]

Hi @Steve Hooczko 

The data used for the different reports is different, and so some may be accessible by JQL and others not so much...

The example report you noted, the "Cumulative Flow Diagram" (JIRA's version), uses issue change history, and that is not all accessible by JQL query.

Please see this other community post for ideas how to do this: JIRA add-ons for Excel or Google Sheets, the REST API, log extraction via webhook, or marketplace add-ons for purchase.

https://community.atlassian.com/t5/Jira-questions/Export-status-change-history-from-Jira-inc-From-To-Date-Time/qaq-p/716193

Best regards,

Bill