How to do automation reporting for JIRA dashboard gadgets and to schedule the reports for executives

Abdul Kader Broachwala February 5, 2021

Hello,

I have some questions regarding automation reporting. In my organization, I have created different filters and I am using the filters in different gadgets to represent the data to my executives. However, they would like to receive two reports on a daily and weekly basis via email.

Report 1 - Daily open/close ticket report, in this report they would like to see how many tickets were received and how many were completed on a daily basis. The data should represent the total number of tickets titles showing grouped by each user.

Report 2  - Weekly open/close report, in this report the total number of tickets received and how many were completed per user.

I have created a filter and gadget (resolved vs unresolved tickets for 7 days) which I believe provides all the information for the given reports, however, I would highly appreciate it if you could please help me in knowing how to automate and schedule the reports for the executive team? Since the dashboard gadget doesn't provide me with an export option in a pdf or excel format. I need to click on individual status i.e. Resolved vs Unresolved and need to export in the different formats which would take a lot of time and efforts of mine every day.

Is there a way or a plugin to automate the above reports on a daily and weekly basis and forward it to the executive team in a pdf format via email? Please let know if you need any further information.

Looking forward to your response.

Regards,
Abdul

3 answers

1 vote
Sami Linnanvuo _Screenful_ March 18, 2021

Hi @Abdul Kader Broachwala 

We have recently launched a Reports add-on for Jira for this exact purpose. You can create reports form Jira data and have it delivered as a PDF file via email to selected recipients daily or weekly. 

You can learn more from the release notes

1.png

Tara Brown
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 24, 2021

@Sami Linnanvuo That looks like what I need, but we're on Data Center, not cloud. :-/ Any plans to offer it in Data Center? 

Sami Linnanvuo {Screenful}
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
November 25, 2021

@Tara Brown we support Data Center in our self-hosted package, which is offered in our Enterprise tier. It is not available for purchase via the Atlassian Marketplace but you can purchase it directly via our website at https://screenful.com. It works so that we deliver a Docker image that you can install to your own server. You can contact support@screenful.com for more details. 

1 vote
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 7, 2021

You can automatically export and email Jira dashboards using the two apps called Better PDF Exporter and Better PDF Automation.

Here is the guide: https://midori-global.com/products/better-pdf-exporter-for-jira/data-center/documentation/dashboards#automation

jira-dashboard-kanban-report.png

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 5, 2021

Hello @Abdul Kader Broachwala 

If you have a saved filter, you can set up a subscription to email a group of users with the output of the saved filter. You will have to get the executives set up in a user group first. The output won't be pdf or excel. See this post.

https://community.atlassian.com/t5/Jira-questions/How-can-I-subscribe-a-group-to-a-filter/qaq-p/757898

Abdul Kader Broachwala February 5, 2021

Hello Trudy,

Thank you for taking out time and responding to my question. I appreciate your help!

The subscription method won't work for the executives as they do not want to be a JIRA user. Furthermore, they will receive a JIRA link for the saved filter which they do not want. They would like to see an overview of the report in a pdf/excel format for the aforementioned reports daily and weekly. Is there a plugin which helps to make the automation reporting possible in a pdf/excel format? Your advice will be highly appreciated! Thank you

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 5, 2021

Hello @Abdul Kader Broachwala 

I have no need for that sort of app, but I'm sure if you go to the App Marketplace and do a search for "jira export pdf" you could find that information.

https://marketplace.atlassian.com/search?query=jira+pdf+export

Like Bill Sheboy likes this
Jose Ariel Laureano Ramirez August 17, 2021

Hi @Abdul Kader Broachwala 

I am looking for something very similar. Did you find anything helpful in the marketplace?

Suggest an answer

Log in or Sign up to answer