How to export reports filtered by month or year into excel or pdf so that I can send it to client?

Question

How to export reports filtered by month or year into excel or pdf so that I can send it to client, reports should have the below columns :

Ticket Name, Ticket Created date, Ticket Resolved Date, Ticket Closed Date, Time took to respond, Time took to resolve, Time took to close

thanks for your help in advance.

-VB

Aron Gombas _Midori_ · Answer

Better PDF Exporter can do it with PDF, while Better Excel Exporter can do it with XLSX (Excel's native file format). Both support running saved filters, JQL searches and can use any column configuration.

Jack Brickey · Answer

create a jql that meets your needs and then export. if you are going to do this monthly then add a subscription to the filter.

example:

JQL filter: "Resolved This Month" = project in (A, B, C) AND resolutiondate > startOfMonth()

set up a subscription to run at the end of each month. Note some of the fields you want might require post-processing in Excel.