Excel extracting data from JIRA?

[Akhil Reddy]

I need to extract the logged time per issue and per assignee , every month.
Using structure, I can only extract the data for the current month and the previous one.

please provide exact jql query

[Rambabu Patina _Appfire_]

Hi @Akhil Reddy, Welcome to the community.

The Closest add-ons for requirements would be Timesheet reports and gadgets or Tempo timesheets. Have a try.

Thanks,
Ram.

[Aron Gombas _Midori_]

Run literally any JQL and use the Worklog Report template of the Better Excel Exporter app. 

It will create a pivot table from the worklog data. You can freely group that by any dimension, including the assignee and the month columns.

It will look something like this:

[Sandstorm Media GmbH]

Hi @Akhil Reddy,

you could also try our add-on Exply (Charts & Reports) to create your own analytics and/or export the results and raw data to Excel.

Let me know what you think and what you're maybe missing.

sunny regards

Fabian