Exporting JIRA to Excel

Question

I am interested in exporting data into excel (and can do so easily), particularly with studying start and finish times. However I don't see any fields that would be useful to me. Is there anything to measure tasks/epics from the time they are "In Progress" to the time they are "Done/Resolved/Closed" in excel?

So far I only have the "Date created", "Last Updated" , and when it was "Resolved" for dates.

Aron Gombas _Midori_ · Answer

Better Excel is the JIRA add-on to create custom Excel reports from JIRA issues and other data in JIRA.

There is a template called workflow-reports.xlsx which is part of the add-on and which you could customize to your needs. It tracks "Time to Resolution", "Time to First Response", "Time in <status X>" (for each status) and you can extend these time metrics with your own.

See some samples here: http://www.midori-global.com/products/jira-better-excel-plugin/template-gallery#workflow-reports

unknown · Answer

You will need to be a JIRA Admin. If you are not, you will need to ask an Admin to do this. If you are, you can start here;

https://confluence.atlassian.com/adminjiracloud/adding-editing-and-deleting-a-custom-field-776636410.html

Aileen Ly · Answer

Hi Tom, thank you for your reply. I'm not sure what you mean by add a "custom date field"-- would that be another field that goes along with the "label", "Status", "Fix Version", etc.? How would I go about doing that?