How to send an email every week with number of issues in progress and done (using Jira Automation)

[Max Haley]

Looking for an automation rule to send out an email that specifies

1. How many issues are done on the Project
2. How many issues are in progress on the Project

[John Funk · Accepted solution]

Hi Max,

You can create an Automation Rule like below using the #lookupIssues functionality. 

[Max Haley]

Thank you, John!

[John Funk]

You are welcome.  :-)

[Alexis Gutierrez]

I would love to use this on my test board..

[Rilwan Ahmed]

Hi @Max Haley ,

I would suggest to Create filters and add subscription to them. 

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4 

[Max Haley]

Thanks, this is pretty neat its just I can customise the "From" sender by using email automation. I wonder if I can create a filter, and then devise the same email be triggered automatically via automation?