How to write custom report by Epic/Assignee for specified time period which shows time spent by Epic

Question

How do I write a custom report by Epic/Assignee within Epic for a specific time period which will show me the amount of time spent (per ticket) which I can then export to excel for subtotals and totals?

We don't have Confluence.

(Need step by step because I'm not familiar with writing custom reports out of Jira.)

Thank you!

Michał Kowalewski_SolDevelo · Answer

Hi @Dee Garvey and welcome to the community!

If you are open to using the apps available on the Atlassian marketplace then I can recommend the Worklogs - Time Tracking and Time Reports app which was created by the company I'm representing.

The app will allow you to create your desired report and then export it as Excel file. In the example below I generated a report which grouped time logs in the following order:

* Assignee → Epic → Issues

Please take a look at this screeshot:

What's more you can decide which totals should be visible and exported in the report. Please take a look at this screenshot:

Of course, the application contains many more useful features.

If you want me to show you the application book a free demo session where I'll answer your every question or if you prefer contact us via customer portal.

You can try the app now, as you get a free 30-day trial period after installation.

Kind regards,
Michał
SolDevelo Team

Madhu_RVS · Answer

Hi @Dee Garvey

Welcome to the community !!

You can use Jira Rest API's to pull this data and build on your own custom solution. Or if you would be interested in a mktplace app , take a look at

Issue Hierarchy

The app shows your Epic hierarchy in a tree view and time spent rolled up at each parent level. Also we have detailed time spent report as show in the pop up below which can be exported easily to a csv file.

The app has multiple other features which are very useful in project tracking and management.

(Disclaimer: I work on RVS, the vendor for this app)

Trudy P Claspill · Answer

Hello @Dee Garvey

Welcome to the Atlassian community.

There is not functionality available natively in Jira Cloud to create that sort of complex reporting of time spent. That will require a third party app.

Are you willing to consider getting a third party app to meet your requirement?