Custom Report

I want to know if it is possible to create a custom report for the following (and help writing the criteria):

A report that sums all "time spent" (the aggregate time spent field) for a given "Organization" for all tickets that has logged activity within a given time period.

Basically, I want to figure out a way to track how much time our agents have spent working on tickets for an organization for any given month.  For example, I want a report that will list all tickets worked on in January 2018 for ABC Company, and the sum of all the time spent recorded on all the tickets = 40 hours.


ABC Company, January time spent = 40 hours

XYZ Company, January time spent = 25 hours

I am new to JIRA Service Desk, so I am not sure how to write advanced reports or all the fields I have at my disposal.  I don't know the date field I want to use, but I know it is not the ticket created or resolved dates because those dates would not capture all the tickets I am looking to report against.  Maybe there is a "time spent" date history field where I could query all time spent date entries that are between 1/1/18 and 1/31/18 for example?  

Hopefully this makes sense and is something that can be created - thanks for the help community!


0 answers

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,183 views 6 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot