Automation to provide the totals for all status's in a project

Question

I'm trying to create and automated report that communicates daily on:

* Numbers of issues in project
* Numbers of issues in To Do, In Progress & Done status
* Numbers of issues with a particular custom field value

I'm clear on the timing function although the constraint of executing JQL in the initial timing step is bothersome. I only want one posting every day. Not one for each issue

Bill Sheboy · Answer

Hi @Paul Casillas

What problem are you trying to solve by doing this?  Knowing that may reveal other solution approaches.  Thanks!

Until we know that...You could do exactly what you asked in several ways:

* with saved JQL filters and subscriptions to receive emails, 
* with an automation rule and a scheduled trigger* This could only show a maximum of 100 issues in any status using things like the Lookup Issues action
* To show / count more than 100 issues, the rule would need to call the REST API function for a JQL search, and look at the total count (even though only <= 100 issues could be returned)

* with marketplace addons
* etc.

Kind regards,
Bill

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

This is something you should probably do on a dashboard, not by sending a report via email - the email could be out of date within seconds of being sent.

A dashboard with three gadgets (probably all using the same filter for "Project = X") would tell your people the current answers as soon as they opened it (or refreshed it) and wouldn't need any coding or much effort to create.  Each gadget would just need different "group by" settings - Project, Status, and custom field.