Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,552,425
Community Members
 
Community Events
184
Community Groups

How to send reports or filters automatically via emails in excel or csv format

Dear All,

I want to fetch a report which includes count of Open, Resolved tickets and SLA success rate of Response and resolution SLA  of One day data within in a one report only and send via email in a excel or csv format without any manual intervention.

Actually in that report, team wise issue created and resolved count and response and resolution SLA success rate with respective teams. I want all these conditions in one report only.

I  have tried filter section of issues but it doesn't include the count of tickets and also it have the option subscription which can help to send via email but not in excel or csv format.

I have also tried Report section , in which Count is available but send via email functionality is not available and also it is showing data of 48 hours Or 7 days , I want to display data of  one day only in that report.

I am using Jira Service Desk 3.16.0.

Please help me with this and let me know if any work around is available.

Regards,

Prachi

3 answers

2 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 22, 2020

Hello @Prachi Nema 

You can may be try the jira cloud add-on for google sheets, it allow you to create a report based on a filter.

You will be able to choose when to update automatically the data.

https://support.atlassian.com/jira-core-cloud/docs/use-jira-cloud-for-sheets/

https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436

 

Hope this helps

Thanks for your respone. @Mohamed Benziane 

1 vote
Boris Berenberg - Atlas Authority
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.
Apr 30, 2020

You can send a list of issues like this within the body of the email using Notification Assistant for Jira. At this time, we don't support CSV or Excel as an attachment.

0 votes
PhilSpo
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.
Jul 30, 2020

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events