Extracting JIRA tickets for Reporting

[Emmanuel Byron]

I am compiling a Product Health report and I require assistance on extracting all Business as Usual (BAU) tickets from JIRA in order to create a monthly report. Can anyone provide guidance on the process to accomplish this?

[theCode4_company]

Hi @Emmanuel Byron

As previously mentioned, you can use JQL to filter BAU tickets and then export the results to CSV. Please remember that there is a standard Jira limit for exporting 1000 rows.

However, if you want to automate this process, we recommend our free app - Exporter for Jira. With this app, you can:

• Export BAU tickets to various BI tools like Power BI, Tableau, or Looker Studio.
• Build a simple report.
• Schedule refreshes to keep your reports up-to-date.

Our plugin supports the export of up to 20K issues with the free version, and you can upgrade to the PRO version for larger datasets.

We hope this helps! If you have any further questions or need assistance with our plugin, feel free to reach out.

Best regards,
theCode4 Team

[Aron Gombas _Midori_]

You can easily:

1. Run the JQL that collects the tickets for the report. (You can filter by project, by issue type, by the time window, etc.)
2. Select the columns you want to see in the report by selecting and ordering them in the Issue Navigator.
3. Export the result to Excel using the Better Excel Exporter app.

This is a very core feature of the app.

If you want to make it even better you could try these:

1. Make these automatic by running an Excel automation at the end of the month! There is a free companion app for automations.
2. Create a custom Excel template that will provide the exact report you look for by one click. It can use formulas, pivot tables, charts, VBA macros and all the other advanced Excel features.

(Discl. these apps are developed and supported by our team.)

[John Funk]

Hi Emmanuel - Welcome to the Atlassian Community!

You would create query or filter. Then you can export the result of the filter to Excel.