Create report and add columns

[Jordan Paquette]

I am not new to Jira service desk but I'm relatively new to creating custom reports in the product.

I was asked today if it is possible to generate a report that filters the reporter and shows how many tickets were opened in the last 30 days.

I think I have that part figured out using the filters and then I can select the time frame I want to see.

When I export this data to excel as a CSV file, all that there is is the Date column and the count column. I'd like to include the reporters name, maybe the incident number, etc. Is there a way to configure the report to include this information?

Thank you for any information that you can provide!

Jordan

[Angélica Luz]

Hi Jordan,

Welcome to Atlassian Community!

When we export a report using the default options on Service Desk, it will only show those two columns, but I tested here and maybe the option below can help.

I’m not sure if it’s the same that you created, but I created one with the Series Created and selected the Reporter only.

After that, instead of selecting one of the default options, I selected custom dates and selected from January 1st until today (October 29) and the period will be as “Monthly”.

It will show the tickets created by month and then we can click on the number of the desired month to show the tickets and then export it.

I recorded a gif to make it more clear:

This is the best option if you export the report every first day of the month, but if you need to get this information from the last 30 days but not necessarily a full month, you can use a JQL on Issues and Filters > Search issues and then export this issue. Using this option you can also select the desired fields before exporting.

project = PROJECTKEY AND created >= -30d AND reporter in (USER) ORDER BY created DESC 

Hope this helps!

Regards,
Angélica