Is there a way to display the amount of tickets in a list in an automated report?

Question

Hello!

We just upgraded to a paid account and are dipping our toes in some of the automation capabilities in the system. I'm looking to set up a weekly automated report that includes the following information:

- What tickets were completed that week and how many

- What tickets are still open and how many

Is there a way to grab a total amount of tickets in a list such as 14 tickets were added to the list "Done" this week and 10 were added to the list "In Progress" and include that in my list that I'll be emailing out to management in our organization?

Along with that, is there a way to generate a list of who submitted the most reports? I.e. employee A came to our team and reported 5 issues this week, and employee B reported 3.

Any help or advise is appreciated!

Navarambh Software - Gmail · Answer

Hi,

Please refer to the thread below to learn how to setup a subscription

https://community.atlassian.com/t5/Jira-questions/How-to-create-a-subscription-to-a-Report-or-Filter/qaq-p/51006

1. What tickets were completed that week and how many

resolved > -1w

2. What tickets are still open and how many

resolved = empty

3. 14 tickets were added to the list "Done" this week

status changed to done after -1w

4. 10 were added to the list "In Progress"

status changed to "In Progress" after -1w

For more advanced reporting, please consider trying out our app: AIO Reports and Timesheets for Jira

https://marketplace.atlassian.com/apps/1212942/aio-reports-and-timesheets-for-jira?hosting=cloud&tab=overview

Documentation link:

https://aioreports.atlassian.net/wiki/spaces/ART/overview

It allows for advanced reports to be created and emailed out in excel format at set schedule. If you are interested in a demo, please email us at support@aioreports.com and we will be happy to setup once.

Regards

AIO Support

Iain Dooley · Answer

@Brian Mohler the Butler Bot used to be able to count cards, but lost that feature when it went "no code". You can still use the API for comprehensive reporting, though, for example here's a Trellinator snippet I wrote in response to someone with a similar reporting request the other day:

https://gist.github.com/iaindooley/95fde6db4e4547ef9e81da3bb07f64ef

You can read more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271