Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Brian Mohler March 12, 2020

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
Navarambh Software - Gmail
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2020

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

0 votes
Iain Dooley
Community Champion
March 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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events