Exporting month in Excel with issues filtered using JQL query

Question

I am working on a use case where I need to filter issues that were "In Progress" during the last 6 months separated by months. I have achieved it using six different queries as I did not find one for all. Here is my query for last month.

project = CYB2 AND status was "In Progress" after startOfMonth(-1) before endOfMonth(-1)

What I want is to export to excel format (that I can do using the built-in option) including the month mentioned in "after startOfMonth(-1) before endOfMonth(-1)". I am unable to find anything regarding how can I export the month within the excel sheet.

What would be the outcome of the sheets?

I want to build a chart that will show the count of issues that were in progress in that specific month. The chart might look like this.

My Question?

Is there any way I could achieve the use-case by a single query or export the month name along with the exported result?

It would be a great help to me. Thanks a lot

Levente Szabo _Midori_ · Answer

In case you want to skip unpleasant workarounds, a dedicated Excel reporting app like Better Excel Exporter for Jira Cloud can create a report like this with a few clicks, using the built-in templates.

Browse Excel export samples and see if anything inspires you!

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

Fabian Lim · Answer

@Jamshaid

One option you may consider is to write on a custom field the time the ticket was transitioned with jira automation. That way you can export it as a field.

Jamshaid · Answer

Thanks for your reply. Is there any way I could export the month along while exporting excel sheet?