Community
Q&A
Jira Service Management
Questions
Reporting on Jira SD tickets

Reporting on Jira SD tickets

I am trying to pull a report on the year's ticket activity to an excel spreadsheet. It appears that I can only get a format that will allow for links for the ticket totals for each month that dont transfer to excel (except for totals) Is anyone able to pull bulk raw data?

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes

Answer accepted

Your question is a bit confusing.

if you want to export all issues created since the beginning of the year use this JQL...

createddate >= startofyear()

then use the esport function to push to CSV

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Sorry about the confusion (coffee hasn't quite kicked in yet). I used your JQL which will provide all the tickets in the year...but when downloaded to CSV i just get the totals per month and not the actual ticket information so I can filter out unwanted data from the report.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

That really makes no sense. What you should get is a row for every issue including either the fields displayed based on query or all fields depending on the e port option you chose.

Are you on cloud or server? Can you provide a screenshot of you query results and the excel view?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

We are on the cloud...I would agree with you on that is what I like to get but this is what I do get. Here is the pics...thanks in advance for you help Report excel.jpg

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

ok so I don't think you are using the export from the advanced search for issues. please do the following:

click on magnifying on blue sidebar
click on advanced search issues
ensure you are in advanced (JQL) mode
enter the filter I provided
click on the export (box w/ arrow pointing down) at the top once results are shown
choose either current fields or all fields

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

I see said the blind man...I was using reporting section of Jira SD...this now works. Thank you for your help

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Was this helpful?

Thanks!

Jira Service Management

TAGS