Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to automate report generations?


I have been tasked with automating monthly emails which should include a listing of all Epics completed by month for the past 12 months within our project, separated by team.  It would be nice if this data could be graphed to show the number completed each month by team and overall project (Per month)

For reference, the Created vs. Resolved Issues Report is a near perfect example. I believe I can separate my teams for the report generation by creating a filter. But how do I automate this report to be sent out monthly?

1 answer

Hi @Brad Smith 

Short answer: I do not believe such a report as an automated email is possible with out-of-the-box features.

For some work-around ideas to try...

  • Take a look at the built-in dashboard gadgets to see if something would be close to what you need, and then send out an email with a dashboard link
  • Build a filter and save it, sorted by team and resolution date, and have your recipients subscribe on their desired cadence
  • Investigate the Atlassian Marketplace for addon apps for better reporting/dashboard gadgets
  • Using Automation for Jira rules, use the actions for Create Variable and Lookup Issues to custom build that table of values (months and teams) and send the result in an email.  Two constraints for this one are maximum number of issues (100) for a single Lookup and maximum size of a rule (if it gets too complex.  As you are doing this for Epics, both constraints may be manageable.
  • Use either of the Atlassian provided plugins for Excel or Google sheets, connect that to a query which refreshes when opened, and then build your own report which you share

Kind regards,

Suggest an answer

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

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,910 views 37 49
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