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

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

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!

2 answers

0 votes
Iain Dooley Community Leader Mar 12, 2020

@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

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

Suggest an answer

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

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,653 views 16 7
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