Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Monthly Management Report in Excel for the Activities Edited

I would like to generate the custom monthly report and export to excel for management reporting.  Can be saved as a template for future use.  Typically, I would like to have the following:

JIRA#,

Project Name, --> Currently, this isn't available in the drop-down list

Status (Done, Completed, Ready For Production, Deployed)

Assignee -->  Currently, it is showing the last assignee but is there anyway to have a checkbox with all assignees for a task so that I will be able to identify who all worked on a particular task

other columns can be optional based on the requirement.

Also, generating current, previous month and specific month report from the drop-down will be helpful.

2 answers

1 accepted

1 vote
Answer accepted
Jack Community Leader Jul 14, 2021

Consider using this free solution- jira-cloud-for-google-sheets-official 

set up your JQL filter in Sheets and schedule to run monthly.

Thanks for providing the free solution.  It is working as expected.

0 votes

Is Excel a strong requirement here?

If not, you can easily solve this by creating a saved filter with your desired columns and export the result to PDF with the Better PDF Exporter app:

jira-issue-list-table-export.png

(Discl. I'm a developer working on this paid and supported app.)

I think the sample looks good but can I define specific period report?  Also, if possible, can I get a free solution from the community?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

786 views 2 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you