Exporting month in Excel with issues filtered using JQL query

[Jamshaid]

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

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]

Hi @Jamshaid

Unfortunately, this is not available via Jql. There are various plugins in the market that can generate the same report you mentioned withouth having to export.

If you can't get a plugin, you will have to create a macro that gets the count for each exported spreadsheet and graph the chart.

Regards,

[Jamshaid]

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

[Fabian Lim]

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