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; } } }

Reports - How to create and export

GilK

Hi,

I want to have an excel report that will the display the following:

For each user, how many hours he worked per component. I want to separate work on bug with work on task/story.

Something like:

John, February 2012

Component: X, 4d bugs, 8d tasks

Component: Y, 3d bugs, 12d tasks

etc...

How do I achieve it?

Thanks,

Janiv/

Accepted answers

Midori

This is a fairly custom request, thus there is (probably) no out-of-the-box solution.

You can (relatively) simply implement this and similar reports using our JIRA PDF View Plugin:

Run the filter that returns the set of input issues, and invoke the plugin through the "PDF" link in the "View" dropdown menu.
Write a little Groovy script that iterates over the returned collection of issues, and:
Build a map of <username> -> <month> -> <component> -> <statistics>. Statistics should contain separate counters for bugs, tasks, etc. The Multimap implementations in Guava will make it very easy.
Iterate over this map and format the values into the PDF, which then the plugin for download for you.

This is fairly straightforward to implement, and you can follow these tutorials:

Write the Groovy scripts: http://midori.hu/products/jira-pdf-view-plugin/documentation/
Customizing the PDF content: https://studio.plugins.atlassian.com/wiki/x/lQEq

Here is the sample output of a timesheet report that works somewhat similar:

All comments

Alex Suslin

Create a JQL query you need, than Views->Excel and using Pivot table you will be able to achive your goal

---

After you have your excel report, go to Insert->Pivot Table and select the the table (from titles till end of the table, check that no rubish data is selected, just table with headings).

After that you will have Pivot table Field List and 4 areas to filter and visualize your data.

Drag to Column Labels: Issue Type

Drag to Row Labels: Component/s

Drag to Values: Time Spent

after that you will have something you've described.

Example:

Count of Time Spent	Column Labels
Row Labels	Bug	Improvement	New Feature	Sub-task	Task	Grand Total
(blank)	100	10	15	5	1	131
Grand Total	100	10	15	5	1	131

I the example above I have no any components, so you report will have more rows

GilK

Thanks Alex,

What JQL query will bring me for each user, how many hours he worked per component?

Thanks,

Alex Suslin

As JQL applies only for issues, and as I understand no need to track 'from' and 'to' date, empty JQL will work, that returns all the issues.

After Export to Excel you will have an ability to filter the necessary data as you wish

GilK

Do you have any sample how to get each user's hours seperated by issue type?

Thanks

Raimonds Simano1

You can try eazyBI reporting application for JIRA which will allow you to create user work log reports by projects / components as well as by any other JIRA standard or custom field.

GilK

Thanks,

I did not find a way to download it.

I've signed up.

Any idea?

Thanks,

Raimonds Simano1

Leaving response here as well - eazyBI is not downloadable JIRA plugin but is software as a service web application which downloads data from JIRA using REST API and then you use https://eazybi.com to analyze your data.

Raimonds Simano1

Now also installable eazyBI plugin for JIRA is available https://marketplace.atlassian.com/plugins/com.eazybi.jira.plugins.eazybi-jira

Midori

This is a fairly custom request, thus there is (probably) no out-of-the-box solution.

You can (relatively) simply implement this and similar reports using our JIRA PDF View Plugin:

Run the filter that returns the set of input issues, and invoke the plugin through the "PDF" link in the "View" dropdown menu.
Write a little Groovy script that iterates over the returned collection of issues, and:
Build a map of <username> -> <month> -> <component> -> <statistics>. Statistics should contain separate counters for bugs, tasks, etc. The Multimap implementations in Guava will make it very easy.
Iterate over this map and format the values into the PDF, which then the plugin for download for you.

This is fairly straightforward to implement, and you can follow these tutorials:

Write the Groovy scripts: http://midori.hu/products/jira-pdf-view-plugin/documentation/
Customizing the PDF content: https://studio.plugins.atlassian.com/wiki/x/lQEq