Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Dee Garvey
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 15, 2024

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!

3 answers

1 vote
Madhu_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 16, 2024

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)

Epic Hierarchy - New.PNGEpic Hierarchy - Worklogs pop up.PNG

0 votes
Michał Kowalewski_SolDevelo
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 18, 2024

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:

  • AssigneeEpicIssues

Please take a look at this screeshot:

community 1.png

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

community 2.png

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 

0 votes
Trudy Claspill
Community Champion
October 15, 2024

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?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events