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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Jira tickets report automation

Is there a way So that we can schedule a JIRA tickets report ( this is based on a JQL output) better to meet customer needs, I'm trying to schedule a report of total tickets created daily, and I will pick it up from google drive and connect that to an application where I am doing a BI reporting.

Could someone tell me please, is there such a reporting built into the JIRA service desk?

Many thanks and kind regards

~Wasim

2 answers

1 vote
Jack Community Leader Nov 19, 2020

You can create and save a filter using JQL (click in the search and advanced search). Once you save it you can set up a subscription to run the report on a give schedule and include various parties.

Jack Community Leader Nov 20, 2020

you don't manage subscriptions in the Jira Cloud for Excel. you create a subscription w/in Jira itself. 

  1. Advanced search for issues
  2. enter JQL and get desired results, columns, etc
  3. save filter and give it a name
  4. click on the details link at the top of the filter
  5. click on manage subscriptions
  6. configure desired subscription w/in the provided capabilities

Hi Jack,

I understand and agree your steps in getting the results from JQL, saving and manage subscriptions.

My question  here is how to select a custom schedule as per our requirement in 

"jira cloud for sheets" Addon.

Jack Community Leader Nov 20, 2020

For Sheets, I have not done this so can't say for sure. Your original post wasn't calling out Jira Cloud for sheets so I was answering accordingly.

I poked around in the Community and found a few posts that might help. From what I read Sheets does allow for automatic refreshing but no clue how it works or if you can specify the schedule to meet your needs. Here are some related posts you might find useful:

Unable-to-Schedule-Auto-refresh-in-Google-Sheets 

How-can-I-schedule-automate-Excel-reports-in-Jira 

0 votes

Filter subscriptions are an under-utilised feature of Jira.

Hi Warner,

Will this work for Jira Cloud ? If not could you could you provide any work around for Jira Cloud.

Jack Community Leader Nov 20, 2020

yes it works for cloud that is why I suggested it above. Have you attempted to set this up and having issues?

Hi Jack,

 

Thankyou for the response.

I have made the JQL query and using Jira cloud for Excel Addon (Cloud Jira). There in schedule i can view Options Hourly,Daily, weekly and the current day.

But i want to have custom option for every Month from 1st to 30th or 31st or startof the month  and end of the month.I tried in my ways to get the custom selecting option as per our requirement.

For Subscriptions for Jira - Filter Manager, it works in Server and Data center.

spread sheet.PNG

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

133 views 0 4
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