nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira tickets report automation

WasimBuden

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

Accepted answers

All comments

Jack Brickey

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.

Kat Warner

Filter subscriptions are an under-utilised feature of Jira.

rreddy_ve3vnn

Hi Warner,

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

Jack Brickey

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

rreddy_ve3vnn

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

Jack Brickey

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

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

rreddy_ve3vnn

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 Brickey

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management